hi guys,
im curious as to whether you guys know of any limits on iis that keeps it from allowing more than a certain number of connections at one time.... honestly i dont even know if im asking the right question...
but here is my problem...
im just about done with a php site ... and have been testing it on iis5...
i made a dummy application that does nothing but query my mysql db over and over again in a loop with different queries...
heres what i found...
the db seems to average around 150 queries per second (retrieval queries and a couple of update queries per loop... maxing at about 600 queries persecond...but avg is 150 or so.... i dunno if this is a good number or not... i know for a fact that my site will require more than that.... i figure if the db cant handle so much load... it just slows down... no biggie for now...
but what i found to be really disappointing is that when i start multiple instances of internetexplorer, lets say 20 of them doing the same thing... only about ten will not result in a page not found error (keep in mind that im running ie on the same machine as the server)...
this led me to conclude tht its iis that is sucking hard...and not my code or not my database....
what id like to know now is.... what would be a good solution...
i would like my site server to be able to handle a thousand users or more hitting the same page within minutes of each other...
now im a newbie... i dont know if this is realistic from an 'i cant afford a very expensive server' standpoint... but if it is... if you guys can suggest a solution...or a place where i should start looking into.... i would very much appreciate it... thanks a bunch...
ron