My workplace has an oracle database with a very large number of spatial tables.
Therefore, it takes a long time to load the oracle connection in QGIS.
Does anyone know how this could be speed up?
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It only takes a minute to sign up.Sign up to join this community
The time is spent for reading metadata of all available tables. By looking at the GUI of QGIS it does not offer a proper method for speeding it up. Checking the "Only look for user's tables" would work if you can change the ownership to QGIS user but if you work in an enterprise that is probably not possible and a bad idea anyways.
There should be a possibility to restrict the list of tables before starting to read the metadata. Easy start would be to add an option "only look in user_sdo_geom_metadata" while now there is only an option "only look in all_sdo_geom_metadata". Then you could simple create a new Oracle user for QGIS and register just the necessary tables and views into user_sdo_geom_metadata.
Another option would be to make QGIS UI to offer a possibility to make a new Oracle DB connection with a user defined table list. In GDAL it is made by adding a comma delimited list at the end of the connection string as described in http://www.gdal.org/drv_oci.html