The application I am developing currently integrates oracle 8 packages on PHP 4.3.4 on RedHat 7.3.
The problem is: under load, i.e. when more than say 200 records are returned by a package it takes an unacceptly long time. In one case about 2000 records are returned and the speed varies between 1:47 to 3:48 minutes!
When I use a straight SQL-query (no package) I get the results in about 9 seconds. And yes, both database queries (package and straight SQL) are done through adoDB.
Does anyone know whether adoDB doesn't handle Oracle 8 packages correctly or had similar experiences?
Can't adoDB handle Oracle 8 packages?
Moderator: General Moderators
Re: Can't adoDB handle Oracle 8 packages?
While I haven't had that exact experience, I can say with great certainty that if you need the extra performance, and the DB is one that is supported for it, the C-library version is *much* faster.patrikG wrote:The application I am developing currently integrates oracle 8 packages on PHP 4.3.4 on RedHat 7.3.
The problem is: under load, i.e. when more than say 200 records are returned by a package it takes an unacceptly long time. In one case about 2000 records are returned and the speed varies between 1:47 to 3:48 minutes!
When I use a straight SQL-query (no package) I get the results in about 9 seconds. And yes, both database queries (package and straight SQL) are done through adoDB.
Does anyone know whether adoDB doesn't handle Oracle 8 packages correctly or had similar experiences?
Adodb took the time to do a c extension/library version which allows it to run *much* faster. While I havent used it because most of the DB's I use regularly arent supported, the number of posts on the adodb forums commenting on the difference was extreme.
Well worth the hassle to install.
As to the performance issues, load up the new adodb-perfmon tools, and see where the issue is! You might be surprised, and find some sql call erroring out due to an adodb bug, or coding issue.
Its fairly well written, although the output formatting leaves a ton to be desired.