RE: [PHP] Performance: PHP vs. Visual Basic

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:mkwkm@worldnet.att.net] 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 <mkwkm@worldnet.att.net> -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net For additional commands, e-mail: php-general-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net