Results 1 to 6 of 6
  1. #1
    Join Date
    Nov 2001

    Scripting performance comparison

    Can someone give the advantages over these to options for high demand ecommerc site web development:

    ASP and MS SQL


    PHP and Mysql

    What makes either or stick out from the other language, disadvantages from using one or the other.

    Any info will be appreciated

  2. #2
    Join Date
    Jul 2002
    Well, i'd pick MS SQL over MySQL and PHP over ASP .

    But together, i'd go with php and mysql if I was you
    Unlimited Space & Bandwidth
    Providing hosting since 17/99/3003

  3. #3
    PHP + mysql works on every server (windows and unix/linux) while the MS products are for windows. So that's enough reason for me to choose php + mysql and i think linux servers perform much better too. Linux servers are cheaper to hire/buy too so I don't have a clue why anyone would use those crappy MS products

  4. #4
    Join Date
    Jul 2002
    Why not choose MySQL.

    The discussion is more valuable than the article itself -- check both out.
    C#/C++/TCL/Python/PHP developer.
    mark at mark org il

  5. #5
    Join Date
    Nov 2001
    That article was interesting but almost 2 years old. Anyone else have any further insight and technical reasons why one should be used over the other?

  6. #6
    Join Date
    Jul 2002
    Kolding, Denmark
    I would choose MySQL/PHP for the following (mainly performance-related) reasons:

    PHP may be cached, accelerated (pre-compiled) and compressed on the server by using e.g. a combination of PHP-Accelerator ( and mod_gzip ( on Apache on a UNIX-flavor. You may choose a commercial product if you like - Zend is known to work very well ( but PHP-Accelerator and mod_gzip is offering nearly the same performance for free, although without the same level of customer support.

    MySQL is blazingly fast in version 4 if you activate the new cache that allows not only SQL-queries but also the result from the query to be stored in a cache. It requires some additional memory but the performance increase is simply amazing. Note that version 4 also includes transactions in a default setup - this is a much sought after feature that took some tinkering to activate in 3.23.

    eWEEK did a comparison of several Enterprise-grade databases (including MySQL 4.0.1) here:,3959,293,00.asp

    And yes - MySQL 4 is still in beta but in my experience it is just as stable as 3.23 when used for the same type of work, even under very heavy load.

    TCO on ASP/MSSQL and PHP/MySQL? Well, I really don't think there is going to be that much of a difference when it comes to maintaining the servers but you might be in for a nasty surprise if you need to upgrade or expand your initial setup:

    While adding another server with a MySQL-slave is going to cost you the hardware for the server, another MSSQL-server is going to cost you substantially more just for the software. Even adding a second CPU to your database server is going to cost you since MSSQL is licenced per CPU, not per server.

    If you (or your developers) are most comfortable with ASP you should probably stay with that to keep development cost down but by all means go with a MySQL on a UNIX-platform instead of MSSQL - both for performance and price.
    Best regards,

    Anders C. Madsen
    Golden Planet Support -

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts