If you use CF's query caching, you could increase the number of queries CF is allowed to cache. I've always wondered if there is a way to determine how many queries are cached "right now".
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. > -----Original Message----- > From: Jim McAtee [mailto:[EMAIL PROTECTED]] > Sent: Friday, December 28, 2001 1:16 AM > To: CF-Server > Subject: Problems like this everyone should have > > > Two days ago we replaced a CF server with a newer, latest > greatest, etc., > etc. The new machine is running Windows 2000 Server and CF5 > Professional. > Most datasources are Access (I believe using MDAC 2.51 or > later), a few > using dbase (Merant driver) and a few using MS SQL Server 2000. > > The old server (NT4, CF4.01, MDAC 1.5 or so) had 512MB of RAM > and routinely > passed 420MB in memory usage). We cycled the CF Application > Server nightly > and that freed up at least 100MB in memory each night. > > The new server has 2GB (that's 2 GIGAbytes) of RAM. RAM right now is > insanely inexpenive, even more so when I built the machine > several weeks > ago. So, now what do I see in terms of memory usage? > Somewhere betwee > 250MB and 290MB, never higher. I don't see the slow, gradual > increase in > memory consumption that I used to see. Who knows what to > credit - newer > ODBC drivers, ColdFusion5, or Windows 2000 itself. Whatever > the case, it's > welcome. What I'd like, however, is a means of turning all > that unused RAM > into increased performance. I've already got the CF cache > set to 128MBytes, > which should be overkill for something like 10MBytes worth of > source files > for the all CF templates themselves. > > Any suggestions? > > BTW, we had our single busiest day today, peaking at over > 229kBytes per > second (in a five minute sample) of outbound traffic from > this single CF > server. It hardly broke a sweat. > > Thanks, > Jim > > > ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. ------------------------------------------------------------------------------ To unsubscribe, send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body or visit the list page at www.houseoffusion.com
