[Qgis-developer] Simplify provider side

[A Huarte]

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 <cavallini at faunalia.it>
 Para: Médéric Ribreux <mederic.ribreux at medspx.fr>; A Huarte <ahuarte47 at yahoo.es> 
CC: qgis-developer at 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.ribreux at 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 <jef at norbit.de>
 PARA: qgis-developer at 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 at 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 at 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

  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20160201/d515b341/attachment-0001.html>