<html><head></head><body><div style="color:#000; background-color:#fff; font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:16px"><div id="yui_3_16_0_1_1454317355488_13654" class=""><span id="yui_3_16_0_1_1454317355488_13697" class="">Uf.... this behavior is observed in other forums:</span></div><div id="yui_3_16_0_1_1454317355488_13654" class=""><br id="yui_3_16_0_1_1454317355488_15357" class=""></div><div id="yui_3_16_0_1_1454317355488_13654" dir="ltr" class=""><span id="yui_3_16_0_1_1454317355488_13686" class=""><a href="http://osgeo-org.1560.x6.nabble.com/SDO-UTIL-SIMPLIFY-Oracles-version-of-ST-SIMPLIFY-td5101199.html" id="yui_3_16_0_1_1454317355488_13683" class="">http://osgeo-org.1560.x6.nabble.com/SDO-UTIL-SIMPLIFY-Oracles-version-of-ST-SIMPLIFY-td5101199.html</a><br id="yui_3_16_0_1_1454317355488_15362" class=""></span></div><div class="" id="yui_3_16_0_1_1454317355488_13655"><br id="yui_3_16_0_1_1454317355488_15365" class=""></div><div class="" id="yui_3_16_0_1_1454317355488_13655" dir="ltr">The issue 12298 (<a href="https://hub.qgis.org/issues/12298" id="yui_3_16_0_1_1454317355488_13768" style="background-color: rgb(255, 255, 255);" class="">https://hub.qgis.org/issues/12298</a>) of Michael Douchin proposes the use of <font size="3" id="yui_3_16_0_1_1454317355488_13933" style="color: rgb(29, 90, 171); font-family: Arial, sans-serif;" class="">SDO_UTIL.<span style="line-height: inherit;" id="yui_3_16_0_1_1454317355488_15370" class=""><a id="sthref2047" class="" style="text-decoration: none; color: rgb(29, 90, 171); box-sizing: border-box; line-height: inherit;" href=""></a><a id="sthref2048" class="" style="text-decoration: none; color: rgb(29, 90, 171); box-sizing: border-box; line-height: inherit;" href=""></a><a id="sthref2049" class="" style="text-decoration: none; color: rgb(29, 90, 171); box-sizing: border-box; line-height: inherit;" href=""></a></span>RECTIFY_GEOMETRY</font><span style="color: rgb(29, 90, 171); font-family: Arial, sans-serif; font-size: 30px;" id="yui_3_16_0_1_1454317355488_15375" class=""> </span><span id="yui_3_16_0_1_1454317355488_13820" class="">function.</span></div><div class="" id="yui_3_16_0_1_1454317355488_13655"><span class="" id="yui_3_16_0_1_1454317355488_15379">Can be it a good time to test ?</span></div><div class="" id="yui_3_16_0_1_1454317355488_13655" dir="ltr"><br></div> <div class="qtdSeparateBR" id="yui_3_16_0_1_1454317355488_15438"><br><br></div><div class="yahoo_quoted" id="yui_3_16_0_1_1454317355488_15474" style="display: block;"> <div style="font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 16px;" id="yui_3_16_0_1_1454317355488_15473"> <div style="font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 16px;" id="yui_3_16_0_1_1454317355488_15472"> <div dir="ltr" id="yui_3_16_0_1_1454317355488_15471"> <font size="2" face="Arial" id="yui_3_16_0_1_1454317355488_15470"> <hr size="1"> <b><span style="font-weight:bold;">De:</span></b> Paolo Cavallini <cavallini@faunalia.it><br> <b><span style="font-weight: bold;">Para:</span></b> Médéric Ribreux <mederic.ribreux@medspx.fr>; A Huarte <ahuarte47@yahoo.es> <br><b><span style="font-weight: bold;">CC:</span></b> qgis-developer@lists.osgeo.org<br> <b><span style="font-weight: bold;">Enviado:</span></b> Lunes 1 de febrero de 2016 12:02<br> <b><span style="font-weight: bold;">Asunto:</span></b> Re: [Qgis-developer] Simplify provider side<br> </font> </div> <div class="y_msg_container" id="yui_3_16_0_1_1454317355488_15475"><br><div id="yiv1193674145"><div id="yui_3_16_0_1_1454317355488_15476">Also here it does not seem to help.<br clear="none">
All the best.<br clear="none"><br clear="none"><div class="yiv1193674145yqt5533048744" id="yiv1193674145yqtfd73918"><div class="yiv1193674145gmail_quote" id="yui_3_16_0_1_1454317355488_15477">Il 1 febbraio 2016 11:30:36 CET, "Médéric Ribreux" <mederic.ribreux@medspx.fr> ha scritto:<blockquote class="yiv1193674145gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left:1px solid rgb(204, 204, 204);padding-left:1ex;" id="yui_3_16_0_1_1454317355488_15479">
<pre class="yiv1193674145k9mail" id="yui_3_16_0_1_1454317355488_15478">Hello,<br clear="none"><br clear="none">I have made some tests at work on an Oracle 11g database on a layer with <br clear="none">indexes...<br clear="none">It seems that Oracle simplification is worse than direct data access:<br clear="none"><br clear="none">* time for rendering without provider simplification: 10 seconds.<br clear="none">* time for rendering the same layer with provider simplification: 28 <br clear="none">seconds.<br clear="none"><br clear="none">I've tried to change the simplification threshold but it doesn't really <br clear="none">change anything.<br clear="none"><br clear="none">Is there a way to go faster than this ?<br clear="none"><br clear="none">Le 2016-01-29 23:41, A Huarte a écrit :<br clear="none"></pre><blockquote class="yiv1193674145gmail_quote" style="margin:0pt 0pt 1ex 0.8ex;border-left:1px solid #729fcf;padding-left:1ex;"> Hi, it is true, now only it is implementd in the postgres provider.<br clear="none"> <br clear="none"> But it could be implemented easy beacuse of it is entirely similar<br clear="none"> like the Postgre provider does with the ST_Simplify function.<br clear="none"> <br clear="none"> I propose to test a new pull:<br clear="none"> <a rel="nofollow" shape="rect" target="_blank" href="https://github.com/qgis/QGIS/pull/2738">https://github.com/qgis/QGIS/pull/2738</a><br clear="none"> <br clear="none"> Best regards<br clear="none"> Alvaro<br clear="none"> <br clear="none"> -------------------------<br clear="none"> DE: Jürgen E. Fischer <jef@norbit.de><br clear="none"> PARA: qgis-developer@lists.osgeo.org<br clear="none"> ENVIADO: Viernes 29 de enero de 2016 20:36<br clear="none"> ASUNTO: Re: [Qgis-developer] Simplify provider side<br clear="none"> <br clear="none"> Hi Paolo,<br clear="none"> <br clear="none"> On Fri, 29. Jan 2016 at 17:35:58 +0100, Paolo Cavallini wrote:<br clear="none"><blockquote class="yiv1193674145gmail_quote" style="margin:0pt 0pt 1ex 0.8ex;border-left:1px solid #ad7fa8;padding-left:1ex;"> how can I know for which providers does the feature simplification<br clear="none"></blockquote> work<br clear="none"><blockquote class="yiv1193674145gmail_quote" style="margin:0pt 0pt 1ex 0.8ex;border-left:1px solid #ad7fa8;padding-left:1ex;"> server side? AFAIK PostGIS uses it, but what about other DBs, namely<br clear="none"></blockquote> Oracle?<br clear="none"> <br clear="none"> The oracle provider doesn't.<br clear="none"> <br clear="none"> Jürgen<br clear="none"> <br clear="none"> --<br clear="none"> Jürgen
E. Fischer norBIT GmbH Tel.<br clear="none"> +49-4931-918175-31<br clear="none"> Dipl.-Inf. (FH) Rheinstraße 13 Fax.<br clear="none"> +49-4931-918175-50<br clear="none"> Software Engineer D-26506 Norden<br clear="none"> <a rel="nofollow" shape="rect" target="_blank" href="http://www.norbit.de/">http://www.norbit.de</a> [1]<br clear="none"> QGIS release manager (PSC) Germany IRC: jef on<br clear="none"> FreeNode<br clear="none"><hr><br clear="none"> Qgis-developer mailing list<br clear="none"> Qgis-developer@lists.osgeo.org<br clear="none"> List info: <a rel="nofollow" shape="rect" target="_blank" href="http://lists.osgeo.org/mailman/listinfo/qgis-developer">http://lists.osgeo.org/mailman/listinfo/qgis-developer</a><br clear="none"> Unsubscribe: <a rel="nofollow" shape="rect" target="_blank" href="http://lists.osgeo.org/mailman/listinfo/qgis-developer">http://lists.osgeo.org/mailman/listinfo/qgis-developer</a><br clear="none"> <br clear="none"> <br clear="none"> <br clear="none"> Links:<br clear="none"> ------<br clear="none"> [1] <a rel="nofollow" shape="rect" target="_blank" href="http://www.norbit.de/">http://www.norbit.de</a>/<br clear="none"> <br clear="none"><hr><br clear="none"> Qgis-developer mailing list<br clear="none"> Qgis-developer@lists.osgeo.org<br clear="none"> List info: <a rel="nofollow" shape="rect" target="_blank" href="http://lists.osgeo.org/mailman/listinfo/qgis-developer">http://lists.osgeo.org/mailman/listinfo/qgis-developer</a><br clear="none"> Unsubscribe: <a rel="nofollow" shape="rect" target="_blank" href="http://lists.osgeo.org/mailman/listinfo/qgis-developer">http://lists.osgeo.org/mailman/listinfo/qgis-developer</a><br clear="none"></blockquote></blockquote></div></div><br clear="none">
-- <br clear="none">
Sent from mobile. Sorry for being short</div></div><br><br></div> </div> </div> </div></div></body></html>