I'm reading all of these articles that say query caching is an essentual
tool in web application scalability. I have a few questions about caching
queries. Any feedback is much appreciated.
Where is a cached query stored (I'm assuming RAM)?
Is there a rule of thumb to how many queries you can cache on an application
server before you start bogging it down?
Can you edit a recordset of a cached query? If so, do the changes span
sessions?
Are there any downfalls, bugs, limitations to using cached queries? What's
the catch? :)
Many thanks for any responses :)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists