> 1. Does 12,000,000 .cfm pages / month (distributed normally over the day, > peaking around 4 PM ET) seem like a lot for a single xeon 2.0?
Not sure on this. Until you start coming close to maxing out the CPU or memory, I'd say you should stick with your current hardware. > 2. I'm not so sure that we're using RAM effectively, even with mysql set to > use lots of memory and cf set to cache lots of queries and pages. Are you setting the MySQL memory usage in the my.cnf file? How many queries and pages is CF currently set to cache? > 3. Could the use of database client variables be causing peak hour > sluggishness? I've always wondered what sort of performance hit using > database client variables has under load. Would I get a noticable > improvement switching to cookie client variables? This one raises a red flag to me. If I'm not mistaken, the client variables get updated (at a minimum) once per page view, since there is a "last visited" variable that would presumably get set each time. And then of course the client variables need to be read into memory each time as well. I'd say this might be a quick and easy fix that you could make right off the bat to see if it helps out. Ultimately, we should try to find a way to get your mean CPU and memory usage higher if possible. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:205941 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
