>The measure of any performance enhancement is how it works under normal >load. When you look at this, if you're the only one running the application, >you're unlikely to see a significant performance difference. That said, I >usually see more of a difference than that when casually observing the >application debug output.
As Dave mentions, the debug output will help give you at least some idea of what the caching is saving, although only a very rough one in terms of actual production-level results. I wondering though if you are doing something else that is causing the page to display so slowly. Certainly a cached query should not take 2 seconds to retrieve (generally only milliseconds) so my guess is you are dumping a lot of HTML out that the browser is having to churn through. A big HTML table with thousands of rows (commonly with lots of whitespace if you aren't handling that) can really bog the browser down and take a lot of time to display so take a look at what your page is outputting in the source, if you are trying to do something like this. That's another issue altogether of course, and requires other solutions to address. --- Mary Jo ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304300 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
