Re: [Qgis-user] QGIS with ORACLE view bad performance

2014-08-05 Thread Astrid Emde
Hello,

we could get great performance with materialized views with spatial
index instead of normal views.

Best regards

Astrid

Am 05.08.2014 10:55, schrieb Astrid Emde:
> Hello,
>
> I have a project with ORACLE data in QGIS 2.4.
>
> When I load the geometries from a table which has a spatial index, the
> data display is fast and query information is displayed at once.
>
> When I create a view (add an entry to SDO_GEOM_METADATA) and add the
> view to QGIS it is very slow and query information is slow too.
>
> It looks like the spatial index from the table is not used.
>
> Do you have an idea what I can do to get better performance?
>
> Thanks for your helf.
>
> Best regards Astrid
> ___
> Qgis-user mailing list
> Qgis-user@lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-user


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user


[Qgis-user] QGIS with ORACLE view bad performance

2014-08-05 Thread Astrid Emde

Hello,

I have a project with ORACLE data in QGIS 2.4.

When I load the geometries from a table which has a spatial index, the 
data display is fast and query information is displayed at once.


When I create a view (add an entry to SDO_GEOM_METADATA) and add the 
view to QGIS it is very slow and query information is slow too.


It looks like the spatial index from the table is not used.

Do you have an idea what I can do to get better performance?

Thanks for your helf.

Best regards Astrid
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user