Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
- ocifetchstatement performance
- Pat Alessi
December 3, 2004, 4:22 pm
rate this thread
retrieves 4000 rows. However, when I time the ocifetchstatement in
PHP, it is taking about 15 seconds to execute. The web server and the
database are on the same network, so latency is not an issue.
Are there any known performance issues with Oracle and PHP? Is there
another API that I can use that might be faster?
Re: ocifetchstatement performance
How did you determine that the query took 2 seconds - what client did you use,
and did you wait until all the rows were fetched?
Where's the time spent in the 15 seconds from PHP - what's the split between
the OCIParse, OCIExecute and OCIFetchStatement calls?
Are the statements the same in both cases?
Then there's the options of checking execution plans and turning on tracing.
OCI's the fastest API to use if you're connecting to Oracle.
<http://www.andyhsoftware.co.uk/space Space: disk usage analysis tool