none
PHP Performance is really slow RRS feed

  • Question

  • I run a site on Server 2008 R2, with IIS and Sharepoint 2010. I have some PHP pages generating reports from an SQL2010 database server. These pages are included in SharePoint using Page Viewer webparts. When I access the pages through the webpart in SharePoint they typically timeout generating the report or they lock up the IE window and crash it. Some of the report pulls work though, especially if they only pull a very small amount of data from SQL. If they pull a large report it will take forever and eventually the "long running script" error pops up. Outside of sharepoint's page viewer the reports work better, but they're still considerably slower than say FireFox or Chrome. By slower I mean tortoise and the hare slower. I have used DebugBar in IE and I can't find anything that would explain the considerable difference in performance. Has anyone had experience with this problem? Any solutions out there?
    Wednesday, November 13, 2013 6:43 PM

All replies

  • Hi,

    Based on your description, you may try to get the much more memory efficient SQL2010 driver for PHP from Microsoft.

    Microsoft Drivers 3.0 for PHP for SQL Server

    http://www.microsoft.com/en-us/download/details.aspx?id=20098

    I also would like to share the link below with you to check the issue:

    Speed up Windows PHP Performance using Profile Guided Optimization (PGO)

    http://blogs.msdn.com/b/vcblog/archive/2013/05/06/speeding-up-php-performance-for-your-application-using-profile-guided-optimization-pgo.aspx

    Meanwhile, I would like suggest to you post the question on IE development forum for further help.

    http://social.msdn.microsoft.com/Forums/en-US/iewebdevelopment/threads

    The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their

    knowledge or learn from your interaction with us. Thank you for your understanding.

    Hopefully you could resolve your issue soon.

    Thanks

    Tuesday, November 19, 2013 9:41 AM
  • I'm already using the driver to access the database and I'm running PHP 5.4 already. Also, I'm not using a development version of IE. I'm not an IE developer and my customers require that my site is optimized for IE8. I don't see where my post fits with IE development and I honestly feel like this is the typical response to anything posted in these forums (you should post here instead, no you should post there, no post in this other forum).
    Tuesday, November 19, 2013 2:33 PM