Details
-
Improvement
-
Resolution: Unresolved
-
Medium
-
None
-
2011.10, 4.6.0
-
None
Description
Using the $ofset parameter the way it is currently done in arrayquery(), is not efficient: oracle will still fetch all rows starting from the first one, and drop the unwanted one on the client (see php man pages for oci_fetch_xxx for details).
The correct way to implement offset is to wrap the SELECT call in another external select, filtering on ROWNUM - see the oracle php underground manual for details.