https://issues.qgis.org/https://issues.qgis.org/favicon.ico2014-04-08T22:52:51ZQGIS Issue TrackingQGIS Application - Feature request #8689: Oracle provider - speed of listinghttps://issues.qgis.org/issues/8689?journal_id=502602014-04-08T22:52:51ZJürgen Fischerjef@norbit.de
<ul><li><strong>Assignee</strong> changed from <i>Jürgen Fischer</i> to <i>Martin Dobias</i></li></ul> QGIS Application - Feature request #8689: Oracle provider - speed of listinghttps://issues.qgis.org/issues/8689?journal_id=502612014-04-08T23:03:32ZMartin Dobiaswonder.sk@gmail.com
<ul><li><strong>Assignee</strong> deleted (<del><i>Martin Dobias</i></del>)</li></ul><p>The option a) has been implemented in <a class="changeset" href="https://issues.qgis.org/projects/qgis/repository/revisions/5b72daa434b98178cab5c2ba8c78374f7d973e89" title="[FEATURE] Oracle: local cache of the list of tables Caching is done using SQLite database (could...">5b72da</a></p>
<p>For the option b) there is still area for improvement - similarly to Postgres provider, detect the layer metadata in a second step (in ba ckground thread)</p> QGIS Application - Feature request #8689: Oracle provider - speed of listinghttps://issues.qgis.org/issues/8689?journal_id=696042016-04-11T02:12:59ZKen Karlssonken.karlsson@jarfalla.se
<ul></ul><p>Hi!</p>
<p>We have the same problem, but we have to wait for hours before all tables are listed when trying to add an Oracle Spatial-layer.<br />We would like to be able to first choose the table we want to add, and then only scan that table's metadata when added if necessary.<br />This issue seems to be open, but is anyone working on this? <br />We are using QGIS 2.14.1.<br />Thanks in advance!</p>
<p>Best regards, Ken Karlsson</p> QGIS Application - Feature request #8689: Oracle provider - speed of listinghttps://issues.qgis.org/issues/8689?journal_id=768222017-04-30T22:48:10ZGiovanni Manghigiovanni.manghi@gmail.com
<ul><li><strong>Easy fix?</strong> set to <i>No</i></li></ul> QGIS Application - Feature request #8689: Oracle provider - speed of listinghttps://issues.qgis.org/issues/8689?journal_id=813242017-08-01T22:20:51ZRussell Fosterrustyfosty@gmail.com
<ul></ul><p>Hi All,<br />At work we have recently been trialling QGIS as an alternative to some proprietary GIS's. The problem outlined above is our main issue with the software. It takes so long to scan the database tables, gathering all the info it wants. We have connections to databases that have hundreds of spatial objects available, and directories with hundreds of files. It would make sense to use Jonathan's option 'b' to us (mentioned above). We know what we're looking for in the databases, we know it's going to be in the projection we made it, all we need are a list of names so we can click on one to add. A simple query on a spatial db could simply cross check with say ALL_SDO_GEOM_METADATA (for Oracle) just to make sure something is spatial, and that would be enough. The details only become important when trying to add the layer. I hope this is something that gets fixed in later versions, <strong>because so much about QGIS is positive, and a great piece of software</strong>. I'd hate to see it not implemented fully at work because of this one issue, but we don't have time to sit around waiting for it to finally list the one layer we're interested in adding.</p>