« Previous Next »

• 05-06-2009, 5:41 AM

  piraya Joined on 05-06-2009, 9:30 AM Posts 2

  Dedicated Server for web (IIS7/PHP5) and MySQL 5.1 performance problem Reply Contact Hi, I have two servers, the web server is running on a virtual server with II7 configured for PHP and FastCGI. The second server is a dedicated MySQL v5.1 server. Now everything is working fine but when for example installing Joomla the speed is incredibly slow, it can take about 5-10 seconds to load a page. If I change mysql_connect to mysql_pconnect in Joomla db include file everytning works fast. Am I missing something here or is there no other way than to use presistant connections? Kind Regards, raja

  Tags: fastCGI php mysql

• 05-07-2009, 7:23 AM

  In reply to

  Rovastar Joined on 03-13-2008, 10:00 AM London, UK Posts 1,796	Re: Dedicated Server for web (IIS7/PHP5) and MySQL 5.1 performance problem Reply Contact What does the application dev Joomla recommend? I do not know enough about the product to give much more advice.  To test setup a basic page (not in Joomla) and connect to mysql server to see if you can recreate the behaviour. http://www.iisportal.com

• 05-07-2009, 7:46 AM

  In reply to

  piraya Joined on 05-06-2009, 9:30 AM Posts 2

  Re: Dedicated Server for web (IIS7/PHP5) and MySQL 5.1 performance problem Reply Contact Hi, Actually it does not matter whether I use Joomla or if I just create a sample php code that connects to MySQL, the result is the same. Have spent a lot of time regarding this and have found that it has something to do with how MySQL resolves host names. I know it doesn't make sense as it works with persistent connections! Kind Regards, raja

  Tags: fastCGI php mysql

• 05-07-2009, 8:56 AM

  In reply to

  Rovastar Joined on 03-13-2008, 10:00 AM London, UK Posts 1,796	Re: Dedicated Server for web (IIS7/PHP5) and MySQL 5.1 performance problem Reply Contact I haven't used mySQL enough to give a useful answer I suggest to enquire on mySQL support forums for what they use. http://www.iisportal.com