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

J├╝rgen E. Fischer jef at norbit.de
Tue Oct 6 15:18:56 PDT 2015

Hi Steve,

On Tue, 06. Oct 2015 at 17:02:19 +0100, Steve Pritchard wrote:
> When I open a QGIS project that has a layer using the Oracle provider, the
> provider queries for all of the features even though the display area only
> contains a few features:
> mod("featureRequest"."GEOM".sdo_gtype,100) IN (3,7) AND (protocol_id =
> 'WEBSC')

What messages do you get in the message log?

I suppose it's a view and sdo_filter fails on it.  Because sdo_filter requires
a spatial index and qgis probably doesn't find it on that view and tries one
query with sdo_filter that fails and therefore doesn't use it later.  Another
problem might be the SRID.

And without sdo_filter QGIS only resort is to retrieve all and filter them on
the client side.


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/6a9e6e29/attachment.pgp>

More information about the Qgis-developer mailing list