Re: Definition of a cached query

2003-01-16 Thread jon hall
Thursday, January 16, 2003, 6:16:27 PM, you wrote: ps> (Narrowly) I think the answer might actually be NO, because you specified ps> the values below :) Unless I am misunderstanding what you are saying, the answer no, would be incorrect. Query caching does not make any distinction based upon whe

RE: Definition of a cached query

2003-01-16 Thread paul smith
ave received this e-mail in error please delete it immediately and >advise us by return e-mail to [EMAIL PROTECTED] > >* > > >-Original Message----- >From: paul smith [mailto:[EMAIL PROTECTED]] >Sent: Thursday, January 16, 2003 4:57 PM >To: CF-Talk >Subject: Re: Defi

Re: Definition of a cached query

2003-01-16 Thread jon hall
Yes :) cfquery looks at the actual sql string (and the cfquery parameters) to decide whether or not to look at the cache, or make a connection to the database, not just the name. -- jon mailto:[EMAIL PROTECTED] Thursday, January 16, 2003, 5:27:15 PM, you wrote: JM> So if I understand that corr

RE: Definition of a cached query

2003-01-16 Thread Joshua Miller
] * -Original Message- From: paul smith [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 16, 2003 4:57 PM To: CF-Talk Subject: Re: Definition of a cached query At 04:18 PM 1/16/03 -0500, you wrote: >Could someone point me to what exactly is a cached query. It's kind of what it says. Th

Re: Definition of a cached query

2003-01-16 Thread paul smith
At 04:18 PM 1/16/03 -0500, you wrote: >Could someone point me to what exactly is a cached query. It's kind of what it says. The record set is stored in memory for the specified time. As long as it hasn't expired, subsequent requests are pulled from memory. On SMARTERyellowpages.com for example

Definition of a cached query

2003-01-16 Thread Robert Everland
Could someone point me to what exactly is a cached query. Like once a use cachedwithin is it pulling the exact data that it did before, or is it going back to the datasource a little faster? What about if I am passing parameters to it, does it have to cache each instance of that query? Robert Ever