[DBAL-93] [ORACLE] Speed improvement of mechanism for limiting query results Created: 16/Feb/11 Updated: 17/Jun/11 Resolved: 17/Jun/11
|Reporter:||Martin Ivičič||Assignee:||Benjamin Eberlei|
Currently the mechanism for limiting query results in Oracle is suboptimal.
Doctrine uses the following pseudo SQL statement to limit query results:
It's much faster to use the following:
The updated code in DBAL/Platforms/OraclePlatform.php would look like this:
With the current implementation the request for fairly complicated query selecting data from multiple tables one of which reaches 2 million rows takes 5.98 seconds comparing to 1.64 with the proposed one.
In addition It would be nice to have the min and max values as SQL query parameters so that Oracle's internal caching mechanisms could take part, but I'm aware of the fact that it would not be so easy to implement.
|Comment by Benjamin Eberlei [ 17/Jun/11 ]|