[Qgis-developer] Oracle provider slow for large datasets - fetches all features every time

[Jürgen E. Fischer]

Hi Steve,

On Wed, 07. Oct 2015 at 16:07:41 +0100, Steve Pritchard wrote:
> I think the problem is with the coordinates given:
> mdsys.sdo_ordinate_array(1,1,-1,-1)
> 
> If I change these to (-1,-1,1,1) the query works fine:

Ah, fixed in 684346a.

> Why does QGIS need to do SDO_AGGR_MBR(...)?

That might be a result of the undetected spatial index.  If so 684346a should
fix that too.


Jürgen

-- 
Jürgen E. Fischer           norBIT GmbH             Tel. +49-4931-918175-31
Dipl.-Inf. (FH)             Rheinstraße 13          Fax. +49-4931-918175-50
Software Engineer           D-26506 Norden             http://www.norbit.de
QGIS release manager (PSC)  Germany                    IRC: jef on FreeNode                         
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 827 bytes
Desc: Digital signature
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20151007/8353ed01/attachment.pgp>