Uf.... this behavior is observed in other forums: http://osgeo-org.1560.x6.nabble.com/SDO-UTIL-SIMPLIFY-Oracles-version-of-ST-SIMPLIFY-td5101199.html
The issue 12298 (https://hub.qgis.org/issues/12298) of Michael Douchin proposes the use of SDO_UTIL.RECTIFY_GEOMETRY function.Can be it a good time to test ? De: Paolo Cavallini <cavall...@faunalia.it> Para: Médéric Ribreux <mederic.ribr...@medspx.fr>; A Huarte <ahuart...@yahoo.es> CC: qgis-developer@lists.osgeo.org Enviado: Lunes 1 de febrero de 2016 12:02 Asunto: Re: [Qgis-developer] Simplify provider side Also here it does not seem to help. All the best. Il 1 febbraio 2016 11:30:36 CET, "Médéric Ribreux" <mederic.ribr...@medspx.fr> ha scritto: Hello, I have made some tests at work on an Oracle 11g database on a layer with indexes... It seems that Oracle simplification is worse than direct data access: * time for rendering without provider simplification: 10 seconds. * time for rendering the same layer with provider simplification: 28 seconds. I've tried to change the simplification threshold but it doesn't really change anything. Is there a way to go faster than this ? Le 2016-01-29 23:41, A Huarte a écrit : Hi, it is true, now only it is implementd in the postgres provider. But it could be implemented easy beacuse of it is entirely similar like the Postgre provider does with the ST_Simplify function. I propose to test a new pull: https://github.com/qgis/QGIS/pull/2738 Best regards Alvaro ------------------------- DE: Jürgen E. Fischer <j...@norbit.de> PARA: qgis-developer@lists.osgeo.org ENVIADO: Viernes 29 de enero de 2016 20:36 ASUNTO: Re: [Qgis-developer] Simplify provider side Hi Paolo, On Fri, 29. Jan 2016 at 17:35:58 +0100, Paolo Cavallini wrote: how can I know for which providers does the feature simplification work server side? AFAIK PostGIS uses it, but what about other DBs, namely Oracle? The oracle provider doesn't. Jürgen -- JürgenE. Fischer norBIT GmbH Tel. +49-4931-918175-31 Dipl.-Inf. (FH) Rheinstraße 13 Fax. +49-4931-918175-50 Software Engineer D-26506 Norden http://www.norbit.de [1] QGIS release manager (PSC) Germany IRC: jef on FreeNode Qgis-developer mailing list Qgis-developer@lists.osgeo.org List info: http://lists.osgeo.org/mailman/listinfo/qgis-developer Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-developer Links: ------ [1] http://www.norbit.de/ Qgis-developer mailing list Qgis-developer@lists.osgeo.org List info: http://lists.osgeo.org/mailman/listinfo/qgis-developer Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-developer -- Sent from mobile. Sorry for being short
_______________________________________________ Qgis-developer mailing list Qgis-developer@lists.osgeo.org List info: http://lists.osgeo.org/mailman/listinfo/qgis-developer Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-developer