SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Zealot
    Join Date
    Aug 2009
    Posts
    166
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Windows Server 2008 running PHP5 - slow connection to mySQL database

    I recently deployed a new webserver. It is running Windows Server 2008 and lastest version of PHP 5. We have a dedicated database server running mySQL.

    I'm running some test pages on the server because i noticed the SQL queries from my PHP pages are running very slow.

    I setup a test page and the query takes about 4 secs to do a simple query. We have an older server that performs the same query lightning fast! that server is running windows server 2003.

    Old server running windows 2003, IIS6, PHP5.
    New Server running windows 2008, IIS7, PHP5 (latest version).

    anyone have any idea what I can do to speed up the connection between winserver2k8 and mysql?

    I'm connecting via the ip address of the database server.

    Is there some setting in php.ini that i need to change?

  2. #2
    SitePoint Author silver trophybronze trophy
    wwb_99's Avatar
    Join Date
    May 2003
    Location
    Washington, DC
    Posts
    10,653
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)
    Which client library are you using to hit MySql?


Bookmarks

Posting Permissions

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