Feature request #12298

Allow Oracle layers features to be simplified server-side before rendering

Added by Michael Douchin about 2 years ago. Updated 8 months ago.

Status:Closed Start Date:03/02/2015
Priority:Normal Due date:
Assigned to:Jürgen Fischer % Done:

0%

Category:Oracle Data Provider
Target version:Future Release - Nice to have
Platform: Resolution:wontfix
Platform version: Pull Request or Patch supplied:Yes
Status info: Tag:

Description

As for PostGreSQL, it would be nice to let Oracle simplify geometries when featching feature for rendering purpose. This would speed up data retrival.

I have not found any suitable Oracle functions to mimic the 2 methods used for PostGreSQL provider : ST_SnapToGrid and ST_SimplifyPreserveTopology. Perhaps it is not feasible ?

Thanks for any feedback.

QGIS_oracle_pre_rendering_simplification.diff (4.4 kB) Michael Douchin, 03/06/2015 09:40 am

History

Updated by Michael Douchin about 2 years ago

Sure, could be. I am not sure if the PostGis "preservetopology" is needed, since we simplify at a pixel level...

Updated by Michael Douchin about 2 years ago

The tolerance parameter could be used to mimic the "snap to grid" function

Updated by Michael Douchin about 2 years ago

A patch attached with a first code running.

  • I have tested it with only one POLYGON layer, and got awkward results, which seems to be caused by simplification leading to POINT or LINESTRING instead of original geometry type. Perhaps the problems lies also in incorrect geometries in my dataset
  • I kept the tolerance used for PostGIS: mRequest.simplifyMethod().tolerance() * 0.8 There is surely a room for improvement here
  • I do not know if the patch is suitable for both Oracle Locator and Oracle spatial

Please test the attached diff file and give feedback or advice

NB: This is the first time I work with Oracle. I invite Oracle Locator/Spatial gurus to participate, since I am a complete newbie here

NB2: You can use the docker/oracle here to set up a test environment.

Updated by Michael Douchin about 2 years ago

I need to to some benchmarking as described in #8725

Updated by Médéric RIBREUX 8 months ago

  • Status changed from Open to Closed
  • Resolution set to wontfix

Hello,

I am closing this one because we have tried but it seems that simplifying from Oracle server just takes much more time than simply retrieving native features.

Oracle database server doesn't seem to be able to simplify features with loading time improvment...

Also available in: Atom