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:260055 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4