[QGIS-Developer] Oracle view loading too slow

PIERRE Sylvain sylvain.pierre at bas-rhin.fr
Tue May 23 08:20:33 PDT 2017

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ā€¦


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

More information about the QGIS-Developer mailing list