All: I need some good old advice. I�m redesigning an application to utilize query caching and the use of Query of Query to speed it up some. So I�m caching one large query and running the application templates using Q0Q. Any time there that there is an insert, update or deletion from the database I�m going to un cache the main query. The QoQ�s will always have correct data as changes happen which shouldn�t be all that often.
My question is when I perform a SQL insert, update or delete is there a way to call and run a query but not have that query add to the execution time of the template. For example maybe and idea is calling a scheduled job to run the query. Regards, James Blaha ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
