Hi,
If I understand your question correctly.
I have little experience in Oracle DB's, but in PostgreSQL/PostGIS, you
can create a Geometry Constraint within your table, which states what
geometry is within the table, which speeds up QGIS in reading table
lists, when loading them.
A quick search online resulted in
https://docs.oracle.com/database/121/SPATL/constraining-data-geometry-type.htm#SPATL584
Hope this helps!
Regards,
Richard.
On 02/07/2018 14:34, Bryan Hall wrote:
Classification: DCL-Internal
Is there a way to configure QGIS to not query the geometry types from
each registered shape with an Oracle database when opening the layer
browser?
I ask because the database I am trying to load data from has 1486
registered tables, for which about 100 are external data (csv) tables
(much slower to query), and a few dozen are huge collection geometry
tables. QGIS currently takes “forever” (more than an hour – I gave up
waiting) for the layer browser to query and load all the entries into
the list. I really like QGIS in general, but this issue makes it
unusable as it is currently.
Thanks in advance,
Bryan
------------------------------------------------------------------------
This email (and attachments if any) is intended only for the use of
the individual or entity to which it is addressed, and may contain
information that is confidential or privileged and exempt from
disclosure under applicable law. If the reader of this email is not
the intended recipient, or the employee or agent responsible for
delivering this message to the intended recipient, you are hereby
notified that any dissemination, distribution or copying of this
communication is strictly prohibited. If you have received this
communication in error, please notify the sender immediately by return
email and destroy all copies of the email (and attachments if any).
_______________________________________________
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
--
*_Richard McDonnell_*
*GIS Specialist PgD GIS AssocSCSI*
*OPW FRM Data Management*
*52 Stephens Green, Dublin 2.*
TEL: 01 6476543
OPW - Ag féachaint don am atá le teacht - Ag caomhnú ón am atá thart
OPW - Looking to the future - Caring for the past
***********************************************************
Email Disclaimer: http://www.opw.ie/en/disclaimer/
_______________________________________________
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user