RE: [PHP] Performance: PHP vs. Visual Basic
Thanks for the clarification... Anyone have any benchmarks of the MySQL ODBC driver? Just out of curiousity... --Matt -Original Message- From: Andrew Hill [mailto:[EMAIL PROTECTED]] Sent: Monday, September 17, 2001 9:47 AM To: Matthew Loff; 'Michael Kimsal'; 'Masami Kawakami' Cc: 'php forum' Subject: RE: [PHP] Performance: PHP vs. Visual Basic ODBC isn's slow, but some ODBC drivers are. Comparison test if you have performance issues. ODBC can be faster than native. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Data Integration Technology Providers -Original Message- From: Matthew Loff [mailto:[EMAIL PROTECTED]] Sent: Monday, September 17, 2001 12:01 AM To: 'Michael Kimsal'; 'Masami Kawakami' Cc: 'php forum' Subject: RE: [PHP] Performance: PHP vs. Visual Basic I would agree that the DB is probably the biggest bottleneck... Are you connecting to the DB via ODBC? I'm not an expert at DB stuff outside of the MySQL realm, but I've heard many say ODBC is horribly slow. I don't know ASP that well, but could someone comment on ADODB? It uses OLEDB, not ODBC, correct? I've read that OLEDB is much faster. First and foremost, as Michael said, optimize your SQL... That's the first thing I'd do... Then, check and see how you are connecting to the DB... I think I can safely say, that if you switch to PHP/MySQL, that using MySQL native libs to connect to the database are fastest... But I have been wrong in the past... -Original Message- From: Michael Kimsal [mailto:[EMAIL PROTECTED]] Sent: Sunday, September 16, 2001 11:54 PM To: Masami Kawakami Cc: php forum Subject: Re: [PHP] Performance: PHP vs. Visual Basic Much as I don't like to defend MS, I'll take a stab here. By 40-50 people in an office, I presume you're talking about an intranet of some type - 40-50 aren't constantly hitting it (meaning 40-50 requests per second all the time), but 40-50 are using it throughout the day for various tasks. You don't give the machine specs, but I'd hazard to say, if it's moderate equipment, that there's some DB optimization (or VB optimization) that could be done. 40 people lightly hitting a machine shouldn't cause much of a problem regardless of language used, unless there's some extremely bad coding going on. Are you closing DB connections? Are you avoiding putting objects in session and/or application scope? Are the DB queries optimized properly (proper indices on tables, etc)? Those are just a few things I'd look for. Yeah it'd be great to have you switch to PHP, but some optimization issues are universal, and if it's written poorly in one language, chances are it'll be written poorly in another. Regardless of this, we still recommened PHP to most clients because of the cost issue as well. However, since you've already paid for this software you're running (right?) it's probably worth it to take a while to optimize what you've got first. Michael Kimsal http://www.tapinternet.com 734-480-9961 On Sun, 16 Sep 2001, Masami Kawakami wrote: 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] -- 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]
Re: [PHP] Performance: PHP vs. Visual Basic
Much as I don't like to defend MS, I'll take a stab here. By 40-50 people in an office, I presume you're talking about an intranet of some type - 40-50 aren't constantly hitting it (meaning 40-50 requests per second all the time), but 40-50 are using it throughout the day for various tasks. You don't give the machine specs, but I'd hazard to say, if it's moderate equipment, that there's some DB optimization (or VB optimization) that could be done. 40 people lightly hitting a machine shouldn't cause much of a problem regardless of language used, unless there's some extremely bad coding going on. Are you closing DB connections? Are you avoiding putting objects in session and/or application scope? Are the DB queries optimized properly (proper indices on tables, etc)? Those are just a few things I'd look for. Yeah it'd be great to have you switch to PHP, but some optimization issues are universal, and if it's written poorly in one language, chances are it'll be written poorly in another. Regardless of this, we still recommened PHP to most clients because of the cost issue as well. However, since you've already paid for this software you're running (right?) it's probably worth it to take a while to optimize what you've got first. Michael Kimsal http://www.tapinternet.com 734-480-9961 On Sun, 16 Sep 2001, Masami Kawakami wrote: 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]
RE: [PHP] Performance: PHP vs. Visual Basic
I would agree that the DB is probably the biggest bottleneck... Are you connecting to the DB via ODBC? I'm not an expert at DB stuff outside of the MySQL realm, but I've heard many say ODBC is horribly slow. I don't know ASP that well, but could someone comment on ADODB? It uses OLEDB, not ODBC, correct? I've read that OLEDB is much faster. First and foremost, as Michael said, optimize your SQL... That's the first thing I'd do... Then, check and see how you are connecting to the DB... I think I can safely say, that if you switch to PHP/MySQL, that using MySQL native libs to connect to the database are fastest... But I have been wrong in the past... -Original Message- From: Michael Kimsal [mailto:[EMAIL PROTECTED]] Sent: Sunday, September 16, 2001 11:54 PM To: Masami Kawakami Cc: php forum Subject: Re: [PHP] Performance: PHP vs. Visual Basic Much as I don't like to defend MS, I'll take a stab here. By 40-50 people in an office, I presume you're talking about an intranet of some type - 40-50 aren't constantly hitting it (meaning 40-50 requests per second all the time), but 40-50 are using it throughout the day for various tasks. You don't give the machine specs, but I'd hazard to say, if it's moderate equipment, that there's some DB optimization (or VB optimization) that could be done. 40 people lightly hitting a machine shouldn't cause much of a problem regardless of language used, unless there's some extremely bad coding going on. Are you closing DB connections? Are you avoiding putting objects in session and/or application scope? Are the DB queries optimized properly (proper indices on tables, etc)? Those are just a few things I'd look for. Yeah it'd be great to have you switch to PHP, but some optimization issues are universal, and if it's written poorly in one language, chances are it'll be written poorly in another. Regardless of this, we still recommened PHP to most clients because of the cost issue as well. However, since you've already paid for this software you're running (right?) it's probably worth it to take a while to optimize what you've got first. Michael Kimsal http://www.tapinternet.com 734-480-9961 On Sun, 16 Sep 2001, Masami Kawakami wrote: 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] -- 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]
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:[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]