php performance issue
Posted: Tue Jun 06, 2006 3:26 am
Hello All,
I have php 4.0.5 configured with IIS and Oracle 8 on windows 2003 server. The reason for using an older php version is the compatibility problem with oracle 8 client libraries(i tried using php 4.0.6 which isn't compatible with my oracle version). I have a simple script that connects to the oracle db server, performs searching on a table and returns back the result to be displayed in the form of a HTML table.
The problem is that its pathetically slow, takes almost 4 minutes to return a page with 1000 records. Whereas the same script takes only 3/4 seconds to return the same results on php-4.3.11 with oracle 9i client libraries and apache on windows 2000. I have tried changing configuration options in php.ini like output_buffering to on but the result is still the same. And now its been almost 3 days since I am trying to solve this performance issue.
I wonder if the problem is with the php version problem or the configuration or somehing else. Please help me solve this problem. Any help/suggestion in this regard will be highly appreciated.
I have php 4.0.5 configured with IIS and Oracle 8 on windows 2003 server. The reason for using an older php version is the compatibility problem with oracle 8 client libraries(i tried using php 4.0.6 which isn't compatible with my oracle version). I have a simple script that connects to the oracle db server, performs searching on a table and returns back the result to be displayed in the form of a HTML table.
The problem is that its pathetically slow, takes almost 4 minutes to return a page with 1000 records. Whereas the same script takes only 3/4 seconds to return the same results on php-4.3.11 with oracle 9i client libraries and apache on windows 2000. I have tried changing configuration options in php.ini like output_buffering to on but the result is still the same. And now its been almost 3 days since I am trying to solve this performance issue.
I wonder if the problem is with the php version problem or the configuration or somehing else. Please help me solve this problem. Any help/suggestion in this regard will be highly appreciated.