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?