[Qgis-user] Problem with oracle spatial views

[Richard McDonnell]

Two things you could try, Im not that up on Oracle, but you could try 
Indexing your data, more specifically the geometry, if there is any and 
also a general index over the most used attributes.
Regards,

Richard.

On 15/10/2015 14:00, Florian.Feilmeier at ldbv.bayern.de wrote:
> Hello,
>
> loading a layer lasts very long (several minutes) when opening a project with a layer based on an OracleSpatial view (200000 rows). A project with several layers based on views with many rows won't come to an end when loading. The problem does not exist when connecting to tables. What's the problem and how to overcome it? Any advice will be appreciated.
>
> QGIS 2.10.1-Pisa (64bit)
> Win7 (64bit)
> Oracle 11.2.0.3.0 (64bit)
>
> Regards.
> F.
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-user


OPW - Ag féachaint don am atá le teacht - Ag caomhnú ón am atá thart
OPW - Looking to the future - Caring for the past

***********************************************************
Email Disclaimer: http://www.opw.ie/en/disclaimer/

-------------- next part --------------
A non-text attachment was scrubbed...
Name: richard_mcdonnell.vcf
Type: text/x-vcard
Size: 331 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20151015/165038a4/attachment.vcf>