<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
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.<br>
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.<br>
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.<br>
<br>
ALTER TABLE <b><i>table_name</i></b><br>
ADD CONSTRAINT enforce_geotype_geom CHECK (geometrytype(<b><i>your_geom_field</i></b>)
= '<i><b>POINT</b></i>'::text OR geom IS NULL);<br>
<br>
Just replace the <i><b>Italics </b></i>as required<br>
<br>
I hope this helps a little!!<br>
Regards,<br>
<br>
Richard<br>
<br>
<div class="moz-cite-prefix">On 15/10/2015 16:07,
<a class="moz-txt-link-abbreviated" href="mailto:Florian.Feilmeier@ldbv.bayern.de">Florian.Feilmeier@ldbv.bayern.de</a> wrote:<br>
</div>
<blockquote
cite="mid:AFCA9FCECA6EE048ACD41849D73F1B9801530EC9A7@RZS-EXPM-P14024.rz-sued.bayern.de"
type="cite">
<pre wrap="">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 [<a class="moz-txt-link-freetext" href="mailto:qgis-user-bounces@lists.osgeo.org">mailto:qgis-user-bounces@lists.osgeo.org</a>] Im Auftrag von Richard McDonnell
Gesendet: Thursday, October 15, 2015 4:24 PM
An: <a class="moz-txt-link-abbreviated" href="mailto:qgis-user@lists.osgeo.org">qgis-user@lists.osgeo.org</a>
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, <a class="moz-txt-link-abbreviated" href="mailto:Florian.Feilmeier@ldbv.bayern.de">Florian.Feilmeier@ldbv.bayern.de</a> wrote:
</pre>
<blockquote type="cite">
<pre wrap="">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
<a class="moz-txt-link-abbreviated" href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/qgis-user">http://lists.osgeo.org/mailman/listinfo/qgis-user</a>
</pre>
</blockquote>
<pre wrap="">
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: <a class="moz-txt-link-freetext" href="http://www.opw.ie/en/disclaimer/">http://www.opw.ie/en/disclaimer/</a>
</pre>
</blockquote>
<br>
</body>
</html>