[Qgis-developer] Simplify provider side

[kimaidou]

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]
> 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
>
>
>
> _______________________________________________
> 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20160201/09da3e1c/attachment.html>