OracleSpatial poor performance due to scollable cursor
|Reported by:||msmitherdc||Owned by:||sdlime|
|Component:||Input - Native Oracle Spatial Support||Version:||svn-trunk (development)|
|Severity:||major||Keywords:||rfc 52, query, oracle, performance, optimization|
|Cc:||dmorissette, tamas, aboudreault|
As part of the one pass query optimization, the main cursor retrieving data from Oracle Spatial was changed from OCI_DEFAULT to OCI_STMT_SCROLLABLE_READONLY. This adds significant overhead and slows down data retrieval.
It needs to be determined if the one-pass query optimizations actually need the scrollable cursor and if so, determine the best method of only invoking the scrollable cursor under those circumstances.
Location of the OCI directive is http://trac.osgeo.org/mapserver/browser/trunk/mapserver/maporaclespatial.c#L2210