RE: Query Caching

[Stacy Young]

Title: Message

There's also Tagservlet (http://www.tagservlet.com) which is a J2EE implementation of ColdFusion that supports just about the entire CFML tag library...and soon to be open source if I'm not mistaken. Makes all my Fusebox apps in CF instantly portable to J2EE...which can be mounted on any J2EE app server.

 

Fusebox is a cross-language/platform framework (CFML, ASP, JSP and PHP). I'm sure it has it's shortcomings like any other but from my experience so far it's been solid.

 

 

-----Original Message-----
From: Stacy Young [mailto:[EMAIL PROTECTED]]
Sent: Saturday, September 29, 2001 10:33 AM
To: '[EMAIL PROTECTED]'
Subject: RE: Query Caching

Your right on the money there and yes the group has been working on taglib for fusebox. Currently I'm using the Jrun taglib (Jrun is my app server) but a generic one is in the works. I don't believe Allaire would be to happy if we repackaged their tags with ours.

Stace

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 28, 2001 10:05 PM
To: [EMAIL PROTECTED]
Subject: Re: Query Caching

Well, OK, so this got me curious, since I've been thinking along the same lines as Geoff. I just finished going through the presentation on the Fusebox site, and have a couple of questions, if you don't mind.

It would seem that you must be using DB tags, etc., to implement your Fuseactions. The index.cfm would appear to be the controller, and the dsp_* would appear to be the view, so I assume that the act_* corresponds to the model. Is this correct?

The front page of the Fusebox web site states that JSP will be supported in a future version of the architecture, yet you are obviously using JSP today. What is the real story here?

Looking at some of the examples in the presentation, at first glance it seems that a JSP version of Fusebox could be achieved largely by a Fusebox taglib. Is this in fact what is happening?

Thanks!

--
Martin Cooper

----- Original Message -----
From: "Stacy Young" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, September 28, 2001 4:46 PM
Subject: RE: Query Caching

> Breaks MVC? Not mine! (Fusebox)
>
>
> -----Original Message-----
> From: Geoff Lane [ mailto:[EMAIL PROTECTED]
> <mailto:[EMAIL PROTECTED]> ]
> Sent: Friday, September 28, 2001 6:52 PM
> To: [EMAIL PROTECTED]
> Subject: Re: Query Caching
>
>
> Slightly off topic - but I've noticed A LOT of the traffic on this
> list is about the DB Tag related stuff. Am I the only one who thinks
> that the whole idea of DB tags (for anything other than a very trivial
> site) is really a Bad Idea?
>
> It just seems to me that the domain of storage and retrieval lies way
> outside the domain of display. I'm willing to hear opinions on why
> people use these - but they totally break MVC (which not everyone
> cares about I admit).
>
> And - if the queries where being done in regular Java and only being
> accessed from Tag Labraries - then adding a layer of caching with a
> WeakHashmap or something would be rather trivial - then you'd just
> have a little penalty on a cache miss of having to do the query and
> add the value back into the cache.
>
> On that note - you might be able to sub class the DB Tags to have the
> caching done based on the Query and some parameters passed in.
> Basically, you'd need a singleton instance of the Cache class so that
> all the tags could reference the same object (guess you'd need to do
> some synchronizing on the object whenever you updated the cache). Not
> sure if singletons get GCed - since they keep a reference to an
> instance of themselves - one for someone who knows a lot more about
> the details of the VM than me.
>
> Maybe a starting point at least . . .
>
> On Fri, 2001-09-28 at 16:58, Stacy Young wrote:
> > Is there a taglib that supports query caching? Say for isntance I'm
> > using a SQL Taglib to execute a database query, I'd like to hold the
> > results in memory for X amount of time so subsequent queries of the
> > same "id" are pulled from memory and not another trip to the DB.
> >
> > Thanks!
> >
> > Stacy Young
> > Surefire Commerce
> > tel: 514-380-2700 ext 3234
> > http://www.surefirecommerce.com <http://www.surefirecommerce.com>  <
> http://www.surefirecommerce.com <http://www.surefirecommerce.com> >
> >
> > "It all started with a Mouse." -Walt Disney
> >
> --
> Geoff Lane <[EMAIL PROTECTED]>
> Ph: (773) 972-7136
> PGP Key: http://www.frognet.net/~glane/key.html
> <http://www.frognet.net/~glane/key.html>
>
>