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.
php performance issue
Moderator: General Moderators
Re: php performance issue
I wouldn't use such an old version of PHP, since there are very important security features and fixes in later version.rzabin wrote: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.
You are comparing apples to oranges. You need to use php 4.3.11 or later with IIS with oracle 9i client.
It could be the difference from Oracle 8 library optimization to Oracle 9i Optimizations. No way to tell. From what I have read, Oracle 9i is quite fast.
It could also be the difference from IIS and Apache way of initializing pages. Not enough information and it isn't my field to be able to tell you for sure whether or not this would be the case.
My Suggestion
Install PHP 5.1 with PDO and enable Oracle support and see if that is any faster. I remember reading that the Oracle engineers were helping with the PDO library so the PDO library for Oracle could be a lot faster. It might not, but you won't know for sure unless you try it.
- Maugrim_The_Reaper
- DevNet Master
- Posts: 2704
- Joined: Tue Nov 02, 2004 5:43 am
- Location: Ireland