If you really care that much, you're going to be doing some pretty in-depth load testing anyway, so you can vary the different cache amounts (query cache, other manual caches) and get app-specific results. And even then, it's still irrelevant what the absolute efficiency of the query cache is. It's a question of "good enough" that can only be answered by testing your specific app. No preexisting data will be meaningful, because your app will be different than whatever app was used to generate the data.
I'm a huge fan of the "build well, optimize later" approach to programming. Build your app as well as you can, using the simplest means reasonable, and be confident that the app is more than good enough until it's objectively demonstrated not to be. So use the query cache until it's been proven insufficient, and then find a more efficient way to do it. But only worry about it if it's been DEMONSTRATED insufficient. cheers, barneyb On 12/7/05, Terry Ford <[EMAIL PROTECTED]> wrote: > << Honestly, you really ought not to care. >> > > The reason I care is that when you're using a large number of cached queries > of differing (sometimes variable) sizes in a large, highly loaded, dynamic > environment, it's not at all easy to know how many queries you ought to > cache, nor what sort of durations you should place on each one. It would be > quite insightful to know what the average size of a cached query over a > period of time in the cache was, to better tune the "number of queries" > option based on the amount of memory you're willing to dedicate to that task. > > As far as the question of performance, it is very important to understand the > strengths and weaknesses of CF and Java's data types and caching mechanisms > precisely so you can better choose between using one of them or rolling your > own. Anyone truly interested in high performance and optimization "ought to > care". > > Regards, > Terry > -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 100 invites. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:226520 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
