> I've always wondered if there is a way to determine how many > queries are cached "right now".
Unfortunately, I don't think there is, beyond seeing whether another query gets cached or not. > On my machines running CF 4.51 SP2 I usually see "committed > bytes" for the entire server at ~ 200 MB. I've not understood > those who suggest that 1-2GB of memory are required for CF. > For a "singleton" server I would prefer to put the money > into RAID, redundant power, etc. I'm one of those who suggested that amount of memory for CF 4.5.x. There were several reasons for this. One is that, if you had any memory leaks within any components (typically database drivers), CF 4.5.x would show you those leaks very quickly. More physical memory means more time between service cycling, in that unfortunate case. Another reason is that, within heavily-used applications, a sensible strategy to improve performance is to cache as much stuff in memory as possible, and that often consumes very large amounts of memory, particularly if you're caching within the Session scope. I'd agree with you that, with CF 5, this amount of memory may not be necessary, but in general, I prefer to err on the side of more memory than less, since it's so cheap. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm ------------------------------------------------------------------------------ To unsubscribe, send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body or visit the list page at www.houseoffusion.com
