<div dir="ltr"><div><div><div><div><div><div><div><div>Hi all,<br><br></div></div>I would like to apologize : I could not find enough time to finish the tests regarding this issue, and since I did not have a real-world Oracle database (and only in Oracle Locator and not Spatial), I did not go further. <br></div>I also seen some poor performance with server-side simplification, but could not determine why : <br><br></div>* Oracle Locator has native poor perfs ? Would it be better with Oracle Spatial ?<br></div>* I did not configure the right indexes ? At that time, not support was available for Oracle databases in DBManager, so I could not test it<br><br></div>Alvaro, thanks for taking this in charge !<br><br></div>Cheers<br></div>Michaël<br><div><div><div><div><div><div><br></div></div></div></div></div></div></div><div class="gmail_extra"><br><div class="gmail_quote">2016-02-01 12:59 GMT+01:00 A Huarte <span dir="ltr"><<a href="mailto:ahuarte47@yahoo.es" target="_blank">ahuarte47@yahoo.es</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div style="color:#000;background-color:#fff;font-family:HelveticaNeue,Helvetica Neue,Helvetica,Arial,Lucida Grande,sans-serif;font-size:16px"><div><span>Uf.... this behavior is observed in other forums:</span></div><div><br></div><div dir="ltr"><span><a href="http://osgeo-org.1560.x6.nabble.com/SDO-UTIL-SIMPLIFY-Oracles-version-of-ST-SIMPLIFY-td5101199.html" target="_blank">http://osgeo-org.1560.x6.nabble.com/SDO-UTIL-SIMPLIFY-Oracles-version-of-ST-SIMPLIFY-td5101199.html</a><br></span></div><div><br></div><div dir="ltr">The issue 12298 (<a href="https://hub.qgis.org/issues/12298" style="background-color:rgb(255,255,255)" target="_blank">https://hub.qgis.org/issues/12298</a>) of Michael Douchin proposes the use of <font style="color:rgb(29,90,171);font-family:Arial,sans-serif" size="3">SDO_UTIL.<span style="line-height:inherit"><a style="text-decoration:none;color:rgb(29,90,171);line-height:inherit"></a><a style="text-decoration:none;color:rgb(29,90,171);line-height:inherit"></a><a style="text-decoration:none;color:rgb(29,90,171);line-height:inherit"></a></span>RECTIFY_GEOMETRY</font><span style="color:rgb(29,90,171);font-family:Arial,sans-serif;font-size:30px"> </span><span>function.</span></div><div><span>Can be it a good time to test ?</span></div><div dir="ltr"><br></div><div class="hm HOEnZb"> <div><br><br></div></div><div style="display:block"><div class="hm HOEnZb"> </div><div style="font-family:HelveticaNeue,Helvetica Neue,Helvetica,Arial,Lucida Grande,sans-serif;font-size:16px"><div class="hm HOEnZb"> </div><div style="font-family:HelveticaNeue,Helvetica Neue,Helvetica,Arial,Lucida Grande,sans-serif;font-size:16px"><div class="hm HOEnZb"> <div dir="ltr"> <font face="Arial" size="2"> <hr size="1"> <b><span style="font-weight:bold">De:</span></b> Paolo Cavallini <<a href="mailto:cavallini@faunalia.it" target="_blank">cavallini@faunalia.it</a>><br> <b><span style="font-weight:bold">Para:</span></b> Médéric Ribreux <<a href="mailto:mederic.ribreux@medspx.fr" target="_blank">mederic.ribreux@medspx.fr</a>>; A Huarte <<a href="mailto:ahuarte47@yahoo.es" target="_blank">ahuarte47@yahoo.es</a>> <br><b><span style="font-weight:bold">CC:</span></b> <a href="mailto:qgis-developer@lists.osgeo.org" target="_blank">qgis-developer@lists.osgeo.org</a><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><div><div class="h5"> <div><br><div><div>Also here it does not seem to help.<br clear="none">
All the best.<br clear="none"><br clear="none"><div><div>Il 1 febbraio 2016 11:30:36 CET, "Médéric Ribreux" <<a href="mailto:mederic.ribreux@medspx.fr" target="_blank">mederic.ribreux@medspx.fr</a>> ha scritto:<blockquote style="margin:0pt 0pt 0pt 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<pre>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 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" href="https://github.com/qgis/QGIS/pull/2738" target="_blank">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 <<a href="mailto:jef@norbit.de" target="_blank">jef@norbit.de</a>><br clear="none"> PARA: <a href="mailto:qgis-developer@lists.osgeo.org" target="_blank">qgis-developer@lists.osgeo.org</a><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 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 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" href="http://www.norbit.de/" target="_blank">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"> <a href="mailto:Qgis-developer@lists.osgeo.org" target="_blank">Qgis-developer@lists.osgeo.org</a><br clear="none"> List info: <a rel="nofollow" shape="rect" href="http://lists.osgeo.org/mailman/listinfo/qgis-developer" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-developer</a><br clear="none"> Unsubscribe: <a rel="nofollow" shape="rect" href="http://lists.osgeo.org/mailman/listinfo/qgis-developer" target="_blank">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" href="http://www.norbit.de/" target="_blank">http://www.norbit.de</a>/<br clear="none"> <br clear="none"><hr><br clear="none"> Qgis-developer mailing list<br clear="none"> <a href="mailto:Qgis-developer@lists.osgeo.org" target="_blank">Qgis-developer@lists.osgeo.org</a><br clear="none"> List info: <a rel="nofollow" shape="rect" href="http://lists.osgeo.org/mailman/listinfo/qgis-developer" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-developer</a><br clear="none"> Unsubscribe: <a rel="nofollow" shape="rect" href="http://lists.osgeo.org/mailman/listinfo/qgis-developer" target="_blank">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> </div></div></div><br>_______________________________________________<br>
Qgis-developer mailing list<br>
<a href="mailto:Qgis-developer@lists.osgeo.org">Qgis-developer@lists.osgeo.org</a><br>
List info: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-developer" rel="noreferrer" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-developer</a><br>
Unsubscribe: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-developer" rel="noreferrer" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-developer</a><br></blockquote></div><br></div>