Re: [Qgis-user] Problem with oracle spatial views

Thu, 15 Oct 2015 07:26:54 -0700

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, [email protected] 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
[email protected]
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/

<<attachment: richard_mcdonnell.vcf>>

_______________________________________________
Qgis-user mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/qgis-user

Reply via email to