[Qgis-user] Problem with oracle spatial views

[Richard McDonnell]

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, Florian.Feilmeier at ldbv.bayern.de 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:qgis-user-bounces at lists.osgeo.org] Im Auftrag von Richard McDonnell
> Gesendet: Thursday, October 15, 2015 4:24 PM
> An: qgis-user at lists.osgeo.org
> 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, 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 --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20151015/c929d045/attachment.html>
-------------- 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/c929d045/attachment.vcf>