> 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.
My understanding is that all the queries will be cached if they're different. > 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? Fifteen hundred records isn't very many. Query of queries is relatively slow, so I wouldn't be surprised if that approach is slower than just querying the database at runtime for each product. Generating output on the first runtime hit (with CF_ACCELERATE or CFCACHE) will generally provide the best performance if you have a lot of cache hits. CF_ACCELERATE is very memory-dependent, of course, so you'll have to be careful there. CFCACHE is very bad if you don't have many cache hits. Generating static HTML through custom application logic provides the best performance, obviously, but at the cost of not being able to use dynamic stuff at runtime. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292991 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
