Re: query caching and cfcs
It doesn't matter.CF caches queries based on the SQL string, not any kind of variable.As long as you're thread safe without the CACHEDWITHIN attribute, you'll be thread safe with it. cheers, barneyb On Fri, 27 Aug 2004 00:01:33 -0400, Douglas Knudsen [EMAIL PROTECTED] wrote: Ok, I got a cfc named goo.Inside goo I perform a query.Now this cfc goo has an instance stored in the application scope.I want to employ query caching on that query via the cfquery tags cachedwithin attribute. Something tells me this no so good for thread safteyness, eh?Thoughts? Yes, I var scoped the query name.Is it the fact that CF uses the name, sql, and dsn to ID the query in memory make my question moot? Doug -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: query caching and cfcs
if goo is stored is the application scope, and you place your query in the variables scope of goo, it's reliably cached for as long as goo is cached - you have control over it. If you cache the query using the cachedwithin attribute, it'll be cached for as long as the cachedwithin attribute allows OR until the server's query cache limit is reached, which on a shared server, might not be very long at all, depending on a variety of factors. On Fri, 27 Aug 2004 00:01:33 -0400, Douglas Knudsen [EMAIL PROTECTED] wrote: Ok, I got a cfc named goo.Inside goo I perform a query.Now this cfc goo has an instance stored in the application scope.I want to employ query caching on that query via the cfquery tags cachedwithin attribute. Something tells me this no so good for thread safteyness, eh?Thoughts? Yes, I var scoped the query name.Is it the fact that CF uses the name, sql, and dsn to ID the query in memory make my question moot? Doug [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: query caching and cfcs
that's what I figured...danke -- --- Douglas Knudsen http://www.cubicleman.com If you don't like something, change it. If you can't change it, change your attitude. Don't complain. - Maya Angelou [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: query caching and cfcs
if goo is stored is the application scope, and you place your query in the variables scope of goo, it's reliably cached for as long as goo is cached - you have control over it. If you cache the query using the cachedwithin attribute, it'll be cached for as long as the cachedwithin attribute allows OR until the server's query cache limit is reached, which on a shared server, might not be very long at all, depending on a variety of factors. On Fri, 27 Aug 2004 00:01:33 -0400, Douglas Knudsen [EMAIL PROTECTED] wrote: Ok, I got a cfc named goo.Inside goo I perform a query. Now this cfc goo has an instance stored in the application scope.I want to employ query caching on that query via the cfquery tags cachedwithin attribute. Something tells me this no so good for thread safteyness, eh?Thoughts? Yes, I var scoped the query name.Is it the fact that CF uses the name, sql, and dsn to ID the query in memory make my question moot? Doug What a sticky subject. :P s. isaac dealey954.927.5117 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.sys-con.com/story/?storyid=44477DE=1 http://www.sys-con.com/story/?storyid=45569DE=1 http://www.fusiontap.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
query caching and cfcs
Ok, I got a cfc named goo.Inside goo I perform a query.Now this cfc goo has an instance stored in the application scope.I want to employ query caching on that query via the cfquery tags cachedwithin attribute. Something tells me this no so good for thread safteyness, eh?Thoughts? Yes, I var scoped the query name.Is it the fact that CF uses the name, sql, and dsn to ID the query in memory make my question moot? Doug [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]