I was actually told by an Allaire Tech. Rep. that 3-4 times the number of
processors is the correct number.  We have two processors, so we set ours to
7 and we have not had any problems.

When something goes wrong with the CF Server, many people usually think it
has something to do with the server settings instead of their own code.  I
did.  We had a problem where our server was maxing out to 100% about 4 times
a day during a span of two weeks.  After getting all of my server settings
reset, I went back and just checked my newly-hired developer's queries.
Come to find out, he was trying to enter a non-date string into a Date/Time
datatype in our SQL database.  Everytime this Insert query was run, it froze
up 50% of the CPU.  Therefore, after testing his page twice, it crashed our
server.

If you are still having the CPU problem, I would set the simultaneous
requests to 3x the number of processors you have in the machine.  Then, I'd
go run the query optimizer and test all of your code, as a previous poster
commented.

Jeff Stone 
Senior Web Developer
(512) 912-3349 - Phone
(512)�912-3977 - Fax 
--------------------------------------------------------- 
Cirrus Logic, http://www.cirrus.com 
Where Analog Meets Digital 
--------------------------------------------------------- 

------------------------------------------------------------------------------
To unsubscribe, send a message to [EMAIL PROTECTED] with 
'unsubscribe' in the body or visit the list page at www.houseoffusion.com

Reply via email to