It may not be a performance thing based on software in use, it could be
coding problems with the current software.
If you are having problems with 40 - 50 users, you may want to look at where
things are locking up. Table locking because of badly designed update
queries can freeze a good system because of contentions.
How do you handle concurrent locking - what does your code look like for the
initial 20 seconds to load page / slow loading pages?
Run some performance monitoring on sql server, it has good tools for this,
as does win2k.
How much ram do you have? sql server eats ram. (buy more, depending on
whether your monitoring tells you its needed - look at paging). There are
lots of nt tuning faq's out there. Check what you have before dumping it
for something else.
I learnt from someone once its better to find out and understand the problem
than to avoid it. It may come back and bite you.
That said, php is more scalable than vb (flamebait), but its equally easy to
write bad code in both.
SQL Server is a bit of a behemoth, but feed it nicely (ram), and it
generally behaves (*unless you are russian nuclear materials database admins
- see slashdot for more.)
Regards,
Lawrence
-----Original Message-----
From: Masami Kawakami [mailto:[EMAIL PROTECTED]]
Sent: September 17, 2001 11:43 AM
To: php forum
Subject: [PHP] Performance: PHP vs. Visual Basic
Maybe this is one of FAQ, Please give me a URL of this kind of comparison
page, or your experience.
A web server program is running in my office. It consists of Visual
Basic, IIS, and MS SQL Server on Windows 2000. although the performance
is confortable for few users, it is terribly slow for 40-50 users. Once
all of them start to use, it takes more than 20 seconds to open a page
in client browser.
To improve the performance, we have an idea to use, instead of Microsoft,
PHP, Apache, and mySQL/ProgreSQL on Linux. How much will be the
improvement?
We also have plan to enhance the hardware, 1PC for DataBase, 2nd and 3rd
for IIS or Apaches. Which has better scalability, VB or PHP?
--
Masami Kawakami <[EMAIL PROTECTED]>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
