Can't adoDB handle Oracle 8 packages?

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
patrikG
DevNet Master
Posts: 4235
Joined: Thu Aug 15, 2002 5:53 am
Location: Sussex, UK

Can't adoDB handle Oracle 8 packages?

Post by patrikG »

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?
Roja
Tutorials Group
Posts: 2692
Joined: Sun Jan 04, 2004 10:30 pm

Re: Can't adoDB handle Oracle 8 packages?

Post by Roja »

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?
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.

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.
User avatar
patrikG
DevNet Master
Posts: 4235
Joined: Thu Aug 15, 2002 5:53 am
Location: Sussex, UK

Post by patrikG »

Excellent - thanks for the tips, Roja :)
I'll check it out tomorrow at work and let you know what I'll have come up with.
User avatar
patrikG
DevNet Master
Posts: 4235
Joined: Thu Aug 15, 2002 5:53 am
Location: Sussex, UK

Post by patrikG »

After about way too much time debugging, checking this that and the other it turns out that the fault lies with the network-settings of the company I am currently working for. :evil: :roll:
Post Reply