Cache the generated HTML, if you can, and save yourself converting query=>HTML as well. Even if it's only 20ms to do it, that adds up quick under load.
Someone (Dave Watts, maybe?) stated on here that CF apps tend to be CPU bound. That's been my experiences as well, so I generally assume that I'll run out of clock cycles before I run out of RAM. I'm not going to build my database in RAM and use it from there, that's the RDBMS's job, but if I can cache generated information, I will. The main app I develop usually holds somewhere between 1-5MB of cached HTML navigation and layout, depending on usage of the different sites within the app. I also cache a lot of other things, be it other HTML blocks, raw queries, or user information. Add to that the CF template cache, and whatever else it holds, and there's a lot of crap in memory, and I haven't had any problems with it since going to CFMX last fall. Like Matt said, you have to try it to know for sure, but memory is cheap, so use it when you can. barneyb --- Barney Boisvert, Senior Development Engineer AudienceCentral [EMAIL PROTECTED] voice : 360.756.8080 x12 fax : 360.647.5351 www.audiencecentral.com > -----Original Message----- > From: Matt Robertson [mailto:[EMAIL PROTECTED] > Sent: Tuesday, July 15, 2003 1:09 PM > To: CF-Talk > Subject: RE: MX Stability > > > You aren't going to know the answer to that until you try it ... > on a dev server with load testing, of course :D > > Still, if we're talking about 200 titles and 200 urls, 100 > characters each, then thats roughly 40k? Not so bad if you've > got loads of extra memory and know its going to stay that way. > Certtainly if the time ever came to optimize your memory this > would be an obvious candidate for the axe. > > The rub is: what else is going on in your app? Will this be just > another drop in a big bucket or is the bucket full already? > > -------------------------------------------- > Matt Robertson [EMAIL PROTECTED] > MSB Designs, Inc. http://mysecretbase.com > -------------------------------------------- > > > > -- > ------------------------------------------- > Matt Robertson, [EMAIL PROTECTED] > MSB Designs, Inc. http://mysecretbase.com > ------------------------------------------- > > -- > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
