Paul, You should never store database information into a memory variable unless it is within your shopping cart and then I would store it as a array. If you know for certain that only the prices would be updated weekly, and you know for certain on which day, I would use cachedwithin with a timeout of say 6 days.
Hope this helps. Doug B. ----- Original Message ----- From: "Paul Boyd" <[EMAIL PROTECTED]> To: "CF-Talk" <[email protected]> Sent: Sunday, November 12, 2006 4:05 AM Subject: Advice about query caching > Hello everyone, > > First post here, so don't get too hard on me. > > I'm developping a small e-commerce application with less than 1000 products ( around 700). > As far as I know, only product prices would be updated on a weekly basis. > > I'm not too sure how to handle caching. > So here is my question. Is it appropriate to store the products recordset in an application variable within onApplicationStart, and use QoQ for for data manipulation > in my different templates ? or is it better to use Cachedwithin or CachedAfter options from CFquery ? > > your advice is more than welcome. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260056 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
