[QGIS-Developer] Oracle view loading too slow

[PIERRE Sylvain]

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


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