January 27th, 2004, 06:51 AM
Can't adoDB handle Oracle 8 packages?
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?