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 <[email protected]> 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 > [email protected] > List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer > Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer > -- Ian Turton
_______________________________________________ QGIS-Developer mailing list [email protected] List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
