[Qgis-developer] Simplify provider side

Médéric Ribreux mederic.ribreux at medspx.fr
Mon Feb 1 02:30:36 PST 2016


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ürgen E. 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

-- 
Médéric RIBREUX
https://medspx.fr


More information about the Qgis-developer mailing list