[Qgis-user] Performance problems with the ogr file-gdb driver

[Thomas Struller]

Thank you Nyall for the hint to switch off the esri file geodatabase driver over settings-option-gdal-vector drivers. Didn't see that bevor. It triggers a restart of qgis. Thats not nice but that will work.
I hope you are right that arcgis pro realy supports geopackages. Arcgis desktop 10.7 does not.

Thank you for your help

-----Ursprüngliche Nachricht-----
Von: Nyall Dawson <nyall.dawson at gmail.com>
Gesendet: Freitag, 26. Februar 2021 00:00
An: Thomas Struller <thomas.struller at lga-geo.de>
Cc: qgis-user at lists.osgeo.org
Betreff: Re: [Qgis-user] Performance problems with the ogr file-gdb driver

On Thu, 25 Feb 2021 at 23:44, Thomas Struller <thomas.struller at lga-geo.de> wrote:
>
> Hallo List,
>
> since installing QGis 3.16.3 and now continuing 3.18 i have serious performance problems when using the OGR file-gdb Driver.
>
> When i use the ogr file-gdb driver QGis becomes very slow. Not only when I try to edit a file geodatabase, even when i zoom in or out or try to change from the layer-view to the browser-view.
>
> On start up QGis now needs minutes to scan „former project connections“. Is it possible to avoid this scan on startup?
>
> We have a mixed enviroment with arcgis installations and qgis. Sometimes i have to edit a filegeodatabase.
>
> I’m on windows 10 pro, amd ryzen 4750, 32 GB
>
> Does anyone have the same experiences? Is there a solution besides uninstalling the ogr-file-gdb driver?

You could go into Settings - Options - GDAL - Vector Drivers and disable the filegdb driver whenever you're not actively editing a gdb file. I.e. use the stable, optimised openfilegdb driver most of the time and only switch to the filegdb driver when you have a specific need to use it.

The GDAL driver page for the FileGDB driver lists a whole lot of known issues with that driver, which can't be addressed by anyone except for ESRI (as they come from the underlying ESRI SDK). I don't see any likelihood that this driver can/will be improved in the future.

In the long term, there's two reasonable solutions for this setup that I see:
1. With the improved Geopackage compatibility that recent ArcGIS Pro versions bring you may have luck in moving your arcgis workflows away from gdb files and to gpkg, which of course work great in QGIS and other non-esri applications.
2. If funding is available, there's a good chance that edit support can be added to the open source openfilegdb GDAL driver. While this hasn't yet been tested, the gdb format is sufficiently reverse engineered and understood well enough to make this a good possibility.

Nyall


>
> On a imac machine and a linux-mint machine I did not have these performance issues. But as far as i now, there it is not possible to edit esri file geodatabases.
>
> Mit freundlichen Grüßen
>
>
> Thomas Struller
> Diplom Geologe (Univ.), BDG, V18
>
> Sachverständiger nach BBodSchG §18,
> SG1 Historische Recherche
> SG2 Pfad Boden – Gewässer
> Akademischer Geoinformatiker
>
>
>
>
> Tel:    0049 911 12076 111
> Mobil:  0049 170 33 20 494
> Mail:   thomas.struller at LGA-geo.de
>
>
> LGA Institut für Umweltgeologie und Altlasten GmbH
> Christian-Hessel-Straße 1
> 90427 Nürnberg
> info at LGA-geo.de
> www.LGA-geo.de
>
>
>
>
>
>
> Handelsregister: AmtsG Nürnberg HRB 18895
> Umsatzst.-IdNr.:DE219281492
> StNr.:  241/131/30489
>
> Geschäftsführer: Carlo Schillinger, Dr. Jürgen Kisskalt
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Handelsregister: AmtsG Nürnberg HRB 18895
Umsatzst.-IdNr.:DE219281492
StNr.:  241/131/30489

Geschäftsführer: Carlo Schillinger, Dr. Jürgen Kisskalt