>>I assume that a QofQ is identical to a query as far as caching goes --
it's
relationship to another query would not be cached, just the query itself.
i believe that is correct about the caching of QofQ
the number of cached queries can be altered in CF Admin
_______________________________________________________
* Regards,
Richard Lovelock
Westminster City Council - Web Support
Cap Gemini Ernst & Young
Southbank
95 Wandsworth Road
London
SW8 2HG
( 0870 906 7482
_______________________________________________________
-----Original Message-----
From: Damian Watson [mailto:[EMAIL PROTECTED]
Sent: 13 November 2003 12:08
To: [EMAIL PROTECTED]
Subject: Re: [ cf-dev ] Query cacheing
Sorry, I should have been more clear. The server only stores 100 cached
queries at any one time. If a new cached query is run, the oldest will be
knocked off the list of 100 stored and so is no longer cached. It will only
be cached once it is run again. This is why on a server with many
applications you will not get a huge performance increase from cached
queries. Dumping the query into a session or application scope is entirely
seperate from the caching process.
I assume that a QofQ is identical to a query as far as caching goes -- it's
relationship to another query would not be cached, just the query itself.
HTH
----- Original Message -----
From: "Beattie, Barry" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, November 13, 2003 11:57 AM
Subject: RE: [ cf-dev ] Query cacheing
>
>
> >> - and only 100 per server
>
> is that even if you dump the cached queries into session or application
> scope?
> only 100 avail for Q-of-Q?
>
> cheers
> barry.b
>
>
> -----Original Message-----
> From: Damian Watson [mailto:[EMAIL PROTECTED]
> Sent: Thursday, 13 November 2003 8:20 PM
> To: [EMAIL PROTECTED]
> Subject: Re: [ cf-dev ] Query cacheing
>
>
> Yup, server-wide -- and only 100 per server is the setting so on a server
> with a lot of sites the gains are rather minimal...
>
> ----- Original Message -----
> From: "Aidan Whitehall" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Thursday, November 13, 2003 9:50 AM
> Subject: RE: [ cf-dev ] Query cacheing
>
>
> > Cached queries are application-specific rather than session-specific?
>
> Just done a test, and they aren't application specific but server wide.
>
>
>
> --
> Aidan Whitehall <mailto:[EMAIL PROTECTED]>
> Macromedia ColdFusion Developer
> Fairbanks Environmental Ltd +44 (0)1695 51775
> Queen's Awards Winner 2003 <http://www.fairbanks.co.uk/go/awards>
>
> ________________________________________________________________________
> This e-mail has been scanned for all viruses by Star Internet. The
> service is powered by MessageLabs. For more information on a proactive
> anti-virus service working around the clock, around the globe, visit:
> http://www.star.net.uk
> ________________________________________________________________________
>
> --
> ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
>
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> For human help, e-mail: [EMAIL PROTECTED]
>
>
>
>
> --
> ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
>
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> For human help, e-mail: [EMAIL PROTECTED]
>
> --
> ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
>
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> For human help, e-mail: [EMAIL PROTECTED]
>
>
--
** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
For human help, e-mail: [EMAIL PROTECTED]
=======================================================
This message contains information that may be privileged or confidential and is the
property of the Cap Gemini Ernst & Young Group. It is intended only for the person to
whom it is addressed. If you are not the intended recipient, youare not authorized to
read, print, retain, copy, disseminate, distribute, or use this message or any part
thereof. If you receive this message in error, please notify the sender immediately
and delete all copies of this message.
=======================================================
--
** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
For human help, e-mail: [EMAIL PROTECTED]
