Feature request #10075

Oracle Access

Added by roberto loperfido over 5 years ago. Updated over 5 years ago.

Status:Closed
Priority:Normal
Assignee:Jürgen Fischer
Category:Data Provider/Oracle
Pull Request or Patch supplied:No Resolution:duplicate
Easy fix?:No Copied to github as #:18545

Description

Loading the list of tables geometrical could be faster.
We propose to modify the plugin to load only the tables of a schema instead of all tables in all schemas, or to add an option for.
We noticed that the simple views (not Materialized View) are not loaded (you can see but can not be selected).

Another proposal that we propose is to cache the list of tables in order to speed up the loading of any additional layers.
If I load a layer from Oracle, and close the plugin window if I open I have to wait again the list of themes.


Related issues

Duplicates QGIS Application - Bug report #7797: QGIS becomes unresponsive while listing Oracle tables Closed 2013-05-10

History

#1 Updated by Médéric RIBREUX over 5 years ago

Hello,

We propose to modify the plugin to load only the tables of a schema instead of all tables in all schemas, or to add an option for.
There is already a way to select a schema: there is an option called "Only look for user's tables" that only looks in the tables of the user schema.

Another proposal that we propose is to cache the list of tables in order to speed up the loading of any additional layers.
There is a "new table cache feature":#5b72daa434b98178cab5c2ba8c78374f7d973e89 in the Oracle Connector code.

If I load a layer from Oracle, and close the plugin window if I open I have to wait again the list of themes.
A "checkbox have been added":#e392efab15c47ba6cf247dfee10f01de3aa8354a#diff-1e2c1a5166c2554f1a483a41989a5940 to keep the window opened after adding layers

I don't know if this feature request should stay opened as the majority of its points are already fixed ?

#2 Updated by Jürgen Fischer over 5 years ago

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

Also available in: Atom PDF