Re: cachedwithin & queries of same name, caching advise
>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. I already auto-update a cfinclude (html only) for the homepage blog entries and new products pod. I could do that for categories I guess, just have to work out the auto-updating. That's obviously the fastest, don't know why I wasn't thinking of that. I'm not sure about search though. I have search results set up to display products just as a category would, not just links, and provide a lot of search links, like tags really, to bring up various product classes. And of course what anyone searches for. Maybe best to leave to the cachedwithin tag? Thanks for the tips. ~| 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:293357 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: cachedwithin & queries of same name, caching advise
> 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
cachedwithin & queries of same name, caching advise
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
