Bug report #16562

Performance with Oracle datasets

Added by Niels Kjaer over 3 years ago. Updated about 3 years ago.

Status:Closed
Priority:Normal
Assignee:-
Category:Data Provider/Oracle
Affected QGIS version:2.18.0 Regression?:No
Operating System:Windows 7 64-bit Easy fix?:No
Pull Request or Patch supplied:No Resolution:not reproducable
Crashes QGIS or corrupts data:No Copied to github as #:24464

Description

Retrieving, rendering and querying/filtering data from our Oracle databases takes a lot longer than using PostGIS databases.
Our DBAs have investigated the matter and finds the performance to be 10-50 times slower.
Using for example Geomedia as GIS application does not show the same issues, and the Oracle database is not the bottleneck (this has been tested, and both Oracle and PostGIS servers are on the same network, with Oracle on faster hardware).

We believe this could be down to the implementation of how QGIS handles Oracle connections.
If this is indeed the case, and an improvement is more of a feature request we would be happy to discuss sponsoring the development in some way.

We are using Oracle 12C, PostGIS 2.3 on Postgresql 9.5/9.6 and QGIS 2.18.x

Kind regards
Niels
- The Danish Geodata Agency

History

#1 Updated by Giovanni Manghi over 3 years ago

  • Status changed from Open to Feedback

Please raise this matter (as also your willingly to support improvements in this area) in the developers mailing list, here is unlikely it will get the traction it deserves.

#3 Updated by Giovanni Manghi over 3 years ago

it is usual in this cases the interested entity to take contact with one of the company that provide QGIS support and development, as listed on the qgis web site, maybe in this case you prefer the qgis project to make contact with you?

#4 Updated by Jürgen Fischer over 3 years ago

Giovanni Manghi wrote:

it is usual in this cases the interested entity to take contact with one of the company that provide QGIS support and development, as listed on the qgis web site, maybe in this case you prefer the qgis project to make contact with you?

Giving details/feedback would be an option too.

#5 Updated by Jürgen Fischer about 3 years ago

  • Assignee deleted (Jürgen Fischer)

#6 Updated by Giovanni Manghi about 3 years ago

  • Resolution set to not reproducable
  • Status changed from Feedback to Closed

Closing for lack of feedback, please reopen if necessary.

Also available in: Atom PDF