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

Thu, 15 Oct 2015 08:53:12 -0700

The bulk of my experience is in Postgresql (PostGIS), so I may not be pointing you in the correct direction, but one thing I found that slowed Quantum in the Viewing of tables when inserting and the initial load, was down to how the geometry is stored. I found that it takes a while, when Quantum is unsure what geometry type it is dealing with, are you using "geom geometry(GEOMETRY,2157)" to define your geometry type, or are you using "geom geometry(POLYGON,2157)" or "geom geometry(POINT,2157)".....etc. Using the more general "GEOMETRY" slows things down, a quick fix for this...if it is indeed your problem is to use a Constraint, to enforce a particular geometry type. 

ALTER TABLE */table_name/*
ADD CONSTRAINT enforce_geotype_geom CHECK (geometrytype(*/your_geom_field/*) = '/*POINT*/'::text OR geom IS NULL); 

Just replace the /*Italics */as required

I hope this helps a little!!
Regards,

Richard

On 15/10/2015 16:07, [email protected] wrote:

Thank you for your quick response. Spatial Indexes are set for the underlying 
tables. So this should not be the problem. I forgot to mention that, after 
loading the view-based layer zooming and panning works without performance 
problems. But loading the layer(s) when opening the project or adding a new 
view-based layer results in wait time. There must be a problem with loading 
OracleSpatial views.

Regards.

-----Ursprüngliche Nachricht-----
Von: Qgis-user [mailto:[email protected]] Im Auftrag von 
Richard McDonnell
Gesendet: Thursday, October 15, 2015 4:24 PM
An: [email protected]
Betreff: Re: [Qgis-user] Problem with oracle spatial views

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