Jon, Your comment has the meat I�m looking for! Thanks.
What exactly do you mean by: �schedule the cache update, and build in logic on each page request to test if the cache exists, if not, requery immediately� Can you please give me some kind of an example of what the templates involved would have for code and how you would use it? What do you mean by: If possible, abstract access to the cache as much as possible right now...since it is your datastore, you are bound to think of new ways to use it, or need to use it down the road. FYI: My data from the table involved is affected on two sides. On one side there are users on the web entering data which goes into a table. On the other side is a BackOffice were staff edits and queries that data. Querying, updates and deletions only happen in the BackOffice. Regards, JB jon hall wrote: >If this is a high traffic site, or the query takes extraordinarily >long to execute, keep in mind the people hitting the site while the >query is recaching, and right after the server is restarted, etc. They >could get errors, bad data, or long delays... > >I've got an app that does something similar now where we chose to >schedule the cache update, and build in logic on each page request to >test if the cache exists, if not, requery immediately. It works >fairly well under load...other than a few possible CF5 bugs with cached >queries under load that I can't control, but thankfully are rare. > >If possible, abstract access to the cache as much as possible right >now...since it is your datastore, you are bound to think of new ways >to use it, or need to use it down the road. > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
