[Qgis-developer] Simplify provider side

[Médéric Ribreux]

I've made my tests with Oracle Spatial 11g. So I think it will not be 
better with Spatial than with Locator.
My layers have indexes (no complain from QGIS Oracle provider).

Well, we are in feature freeze, so it is not a good time to test some 
new methods of simplification.
I am not sure if we should remove the feature before release because it 
can degrades performances for people that have checked 'Simplify on 
provider side if possible' ?

Cheers,

Le 2016-02-01 13:05, kimaidou a écrit :
> Hi all,
> 
> 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.
> I also seen some poor performance with server-side simplification, but
> could not determine why :
> 
> * Oracle Locator has native poor perfs ? Would it be better with
> Oracle Spatial ?
> * 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
> 
> Alvaro, thanks for taking this in charge !
> 
> Cheers
> Michaël
> 
> 2016-02-01 12:59 GMT+01:00 A Huarte <ahuarte47 at yahoo.es>:
> 
>> 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ü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] [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 [1]/
>> 
>> -------------------------
>> 
>> 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
> 
> _______________________________________________
> 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/

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