If I have various queries using the same query name but different sql can they all be cached at the same time, or will the new one overwrite the last one because of the name? For example, search queries.
I'm wondering how best to serve the category and search results. We have about 1500 products. Would it be wise to make a huge query of all the product info, stick it in the application scope, and always use a query of queries against it? Or something else? Maybe the cf-accelerator tag? mysql query cache? I am on a vps but I don't really know how to test such things, and it's a one man show :-( Thanks. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Check out the new features and enhancements in the latest product release - download the "What's New PDF" now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292964 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
