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]
