if the queury is cached by CF then there are no trips to the database when
the cached query is used - CF does the caching.
The only thing you'd need to worry about is using up too much memory - you
can control the number of queries that CF will cache (via CF administrator),
but not the amount of memory used, so if you cache lots of massive queries
it uses all the memory and CF server goes down...
The simplest way to avoid having to cache (by whatever method), massive
result sets, is to use the maxrows attribute, and if you hit it display a
message saying "more than 100 matches found - you may want to refine your
search", or something like that...
Bert
> -----Original Message-----
> From: Kola Oyedeji [mailto:[EMAIL PROTECTED]]
> Sent: 08 May 2001 12:20
> To: Fusebox
> Subject: RE: XSLT with Fusebox and JSP and whatever else
>
>
> Just search results, at the moment i'm re-executing the query
> on every page
> but only displaying
> 20 to the user at a time, the query is cached but my boss
> asked if there was
> any way to further
> minimise the trips to the database.
>
> KOla
>
> -----Original Message-----
> From: Bert Dawson [mailto:[EMAIL PROTECTED]]
> Sent: 08 May 2001 12:13
> To: Fusebox
> Subject: RE: XSLT with Fusebox and JSP and whatever else
>
>
> I've tried it and it was fast, but not for keeping track of
> form stuff -
> more for caching stuff which is held in a dB but rarely changes.
> I'm not sure why you'd want to pass 1000 records around in a
> hidden form
> field - what is in the records?
>
> Bert
>
>
> > -----Original Message-----
> > From: Kola Oyedeji [mailto:[EMAIL PROTECTED]]
> > Sent: 08 May 2001 12:00
> > To: Fusebox
> > Subject: RE: XSLT with Fusebox and JSP and whatever else
> >
> >
> > Hi Bert
> >
> > >while pondering caching a while back i thought about caching data
> > >as static xml files to avoid hitting the dB repeatedly for
> > dB content which
> > >changes rarely,
> >
> > I'm considering doing something similar for the same reasons
> > except i'm
> > passing a WDDX packet
> > in a hidden form field (a query object of 1000 records)
> >
> > >I came to the conclusion that it would be better to cache a
> > cfscript block
> > >which generates the required data structure (query, array,
> > structure etc.)
> > >Then you call the cached file, get the data into the CF
> > variable, and do
> > >with it what you will...
> >
> > Have you actually tried this? How did you find it performance wise?
> >
> > Thanks
> >
> > KOla
> > -----Original Message-----
> > From: Bert Dawson [mailto:[EMAIL PROTECTED]]
> > Sent: 08 May 2001 11:32
> > To: Fusebox
> > Subject: RE: XSLT with Fusebox and JSP and whatever else
> >
> >
> > My understanding of XSLT is limited to knowing what it stands
> > for, so this
> > may be way off...
> > However, while pondering caching a while back i thought about
> > caching data
> > as static xml files to avoid hitting the dB repeatedly for dB
> > content which
> > changes rarely, but the performance did concern me.
> > I came to the conclusion that it would be better to cache a
> > cfscript block
> > which generates the required data structure (query, array,
> > structure etc.)
> > Then you call the cached file, get the data into the CF
> > variable, and do
> > with it what you will...
> >
> > Bert
> >
> > > -----Original Message-----
> > > From: Louis Zezeran
> > > [mailto:[EMAIL PROTECTED]]
> > > Sent: 08 May 2001 11:27
> > > To: Fusebox
> > > Subject: XSLT with Fusebox and JSP and whatever else
> > >
> > >
> > > Our lecturer has been teaching us about XSLT combined with
> > XML and it
> > > looks very helpful for defining multiple content types (ie
> > HTML, WML,
> > > cHTML etc etc) however the data must be put into XML first. I
> > > have been
> > > thinking up some ideas and I am about to put pen to paper (or
> > > fingers to
> > > keys) on how else to accomplish the task of multiple content
> > > types with
> > > Fusebox without having to go through XSLT. My main problems
> > with XSLT
> > > are
> > >
> > > 1) Speed, it's got to be parsed exra times, but that's not my main
> > > concern.
> > > 2) If the data wasn't in XML before hand, why convert it
> > into XML just
> > > so it can be converted back into something else.
> > >
> > > If the data is already in XML then I can see how it could be very
> > > useful.
> > >
> > > Has anyone use XSLT with or fusebox already? Your input would be
> > > appreciated, cheers people!
> > >
> > > Louis
> > >
> > >
> > >
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
