That's not the behavior I've seen - CF is smart enough to look at the
select criteria of a query and will reuse it based on the criteria, not the
name.
I wrote a site that used the same query name to dynamically build forms
from a data dictionary, and each page (with different select criteria but
the same query name) showed as a Cached Query with debugging turned on.
...Jay
At 10:53 AM 8/25/2000, you wrote:
>You would have 10 cached queries, but because CF refers to queries by name,
>you can only use one of them (the last one executed.) So you'll need to
>change the name of the query for each loop:
>
><cfloop from="1" to="10" index="i">
> <cfquery name="qryName_#i#" datasource="#dsn#">
> SELECT field1
> FROM table
> WHERE field2 = '#i#'
> </cfquery>
></cfloop>
>
>Sharon
>
>-----Original Message-----
>From: Todd Ashworth <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
>Date: Friday, August 25, 2000 12:58 PM
>Subject: questions about "cachedwithin"
>
>
> >To paraphrase the CFWACK:
> >
> >'The ColdFusion caching logic takes <cfif>, <cfloop>, and other dynamic
> >structures in queries into account, ensuring that caching is safe to use
> >within a dynamic environment.'
> >
> >OK .. Say I have
> >
> ><cfloop from="1" to="10" index="Variables.index">
> > <cfquery name="qryName" datasource="#Variables.DSN#"
> >cachedwithin="#CreateTimespan(1,0,0,0)#">
> > SELECT field1
> > FROM table
> > WHERE field2 = '#Variables.index#'
> > </cfquery>
> ></cfloop>
> >
> >I'm assuming in this scenario I will end up with 10 different cached
>queries
> >... or would all of the queries overwrite each other because they all have
> >the same name?
> >
> >Also, does anyone know how much overhead is associated with removing the
> >oldest cached query from memory and replacing it with the newest when the
> >limit is reached? I'm guessing even if it has to be done a lot, it's still
> >faster than than hitting the database for 15 rows of data, every single
> >time.
> >
> >Todd Ashworth
> >
> >
> >---------------------------------------------------------------------------
>---
> >Archives: http://www.mail-archive.com/[email protected]/
> >To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in
>the body.
>
>------------------------------------------------------------------------------
>Archives: http://www.mail-archive.com/[email protected]/
>To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in
>the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
