Paul, I think your method would certainly work, however my experience with e-commerce has been that the full recordset of products is almost never used. By using QoQ against your full recordset, you do limit yourself in some of the functions like true full-text searching that the database just does better (and performs better at) because that's what it was designed for.
Add multiple SKU's, Upsells, and the like and now you have to have 2 or 3 QoQ's for every page request - something that could be accomplished in one query using JOIN's. I also think you open yourself up to problems down the road and make life harder instead of easier. Stock levels are one of those areas. I don't know what you're selling or if you have physical inventory, but depending on how your query/tables are structured, you're going to have build a bunch of additional functions to handle clearing and resetting the application variable whenever a product is sold. IMHO, CachedWithin in your query is a much more maintainable solution with fewer workarounds and pitfalls for you as the developer to worry about. Jon On Nov 12, 2006, at 7:37 AM, Paul Boyd wrote: > I could after that use the request scope to avoid locking. > As long as my application is running, I have the recordsets > available in memory, and i can use QoQ to do all the drill down > data manipulation. > In other words, I would only have one database connection , during > the application startup, if I understood correctly. > > If I need to refresh the cache, I would just recall the application > variable which store the recordset and overwrite it. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:260076 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
