[QGIS-Developer] Oracle view loading too slow

[Ian Turton]

See if this GeoServer discussion helps
http://docs.geoserver.org/latest/en/user/data/database/oracle.html#using-the-geometry-metadata-table


Ian

On 23 May 2017 at 16:20, PIERRE Sylvain <sylvain.pierre at bas-rhin.fr> wrote:

> Hi folks,
>
>
>
> No matter qgis version (2.14, 2.18) , loading  oracle spatial table with
> 20000 rows take few seconds while loading a view  (based on same table)
> with 900 rows take  more than one minute.
>
> Is there some way to tune oracle view to take more reasonable loading time?
>
>
>
> I know that materialized view is a solution, but with frequently dataset
> update this is not the solution here…
>
>
>
> Thanks
>
> Thanks
>
>
>
>
>
> _______________________________________________
> QGIS-Developer mailing list
> QGIS-Developer at lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
>



-- 
Ian Turton
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20170523/b0a164f2/attachment.html>