Re: PHP execute very slow : PHP Version 5.2.6

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 





On 4/10/2010 9:07 PM, Kristijan Marin wrote:
Hi,



I'm experiencing very slow performance of my php scripts ... At first and
for a long time I thought it was Oracle

fault cause I didn't use binding (I rewrote the code ), but the performance
is still bad.

So I tested my sql statement and did some time measurement and found out
that Oracle can fetch  300 records in less

then 2 seconds, but PHP needs  210seconds ... to display it to the user ....
I'm using default php.ini



I have a horizontal menu with buttons to switch pages ..... and just
switching pages takes time with minimum or no oracle interactions.



My php version: 5.2.6

OS: Windows XP sP3 and Windows Server 2008



Testing it in PHPEd using internal PHPEd server and FastCGI ... and also on
Windows 2008 server in IIS ...same results .... both using the same
php.ini....



Would anyone know what could be the cause of this ?



Any hit is appreciated.



Kris



Use microtime() and record execution times at various points in your script. Save the times and its corresponding script line number in a string, with suitable formating <br />s etc. At the end of the script, echo it.

Incidentally, are you echo-ing output to the client as the info is available, or using output buffering? Will make big difference if you are sending a lot of output pieces.

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux