Performance is pretty snappy using CachedWithin... with debug turned on, I'm getting total execution time of 172 ms, which is 156 ms for browse-properties.cfm, 110ms for the pagination CFC to execute, and 16 ms for startup, parsing, compiling, loading, & shutdown. 20 properties are being displayed with... well, actually, you can see the page in question at http://c21ar.wsm-dev.com/cfm/browse-properties.cfm.
I really appreciate your advice for the CachedWithin. That's been a big help! Thanks, Mary Jo! Rick > -----Original Message----- > From: Mary Jo Sminkey [mailto:[EMAIL PROTECTED] > Sent: Sunday, April 27, 2008 1:24 AM > To: CF-Talk > Subject: Re: CachedWithin question... > > >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:304301 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
