Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2001

    Unanswered: SQL Server, php 4, freeTDS & performance

    Hi there,

    We are currently exploring the possibility of migrating from mysql to Microsoft SQL Server. The reason for the move is to make use of the extra functionality.

    We have migrated a website which was running on mysql to SQL Server using the freeTDS library. We have noticed a considerable increase in the time it takes to execute the pages.

    One particular heavy page has gone from 0.16566 sec execution time in mysql to 1.52923 sec in SQL Server. A 10 fold increase.

    I understand that mysql is faster than SQL Server but I would not have expected such a large change.

    We are looking to have about 100 sites working with this configuration, and these performace decreases are concerning.

    Reading the freeTDS FAQ
    describes a strict one-query-at-a-time limitation and a further limitation in php creating new connections.

    • Is anyone using PHP and SQL Server together in a demanding environment? Do they work together well?
    • Is it just a case that we need to optomize the new database?
    • Is freeTDS the only/right solution for the job?

    Any help would be greatly appreciated,


    We are running a redhat 8 system with apache2, php4.3.9 and freetds0.62.4. I connect to MSSQL 2000 on a windows 2000 server.

  2. #2
    Join Date
    Jan 2005
    You are comparing apples to oranges. I prefer to just eat them.

    Run your queries in their native environments to get valid comparisons. The network layer appears to be skewing your results.

    I can see why freeTDS is free - maybe it should be renamed to singleThreadedNotSoFastFreeTDS. MSN Search: MARS YUKON.

    I don't think Microsoft or Sybase has published TDS internals, so anything these people are doing would be a reverse-engineer. It is a cool idea, but it would misrepresent the performance you would see using Microsoft SQL Server in place of MySQL.

    MySQL faster than SQL Server? Avoid the Kool-Aid from whatever cult is promoting this.
    I love deadlines. I like the whooshing sound they make as they fly by. Douglas Adams

Posting Permissions

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