Bryan,
I was having a similar issue before, it was due in my case to QGIS
looking through the whole table to find what kinds of Geometry were in
the table. In my case the addition of Geometry Constraints helped speed
things greatly.
The only other way I know, which is quicker for loading Tables (if you
have already added them as sources) would be to:
In QGIS 2.1X use the DB Manager, and drag and drop the Layers you want
into QGIS, its considerably quicker, also good for adding views!
In QGIS 3.X, you can use the Data Source Manager to add the Layers, Dont
use the icons on the Left (thats the same as the method you are having
issues with), drill down through the Browser instead, you can add them
from there, I find it much quicker. Again its a good method for adding
Views.
Hope it helps, Regards,
Richard.
On 02/07/2018 17:03, Bryan Hall wrote:
Classification: DCL-Internal
Richard,
Yes, I understand how to do that, and this is not the issue.
The problem I have is that when I open the database connection, the
layer/table list polls the database for each and every accessible
item. That takes considerable time (I let it finish – the runtime was
about an hour and a half).
I am asking if there is a configuration setting to disable this lookup
(beyond just polling the mdsys.sdo_geom_metadata_table for the
schema/table/column names) so that I can just open the browser, select
a table, and go on without waiting for it to load metadata about all
the other tables into the browser first.
Bryan
*From:*Qgis-user [mailto:qgis-user-boun...@lists.osgeo.org] *On Behalf
Of *Richard McDonnell
*Sent:* Monday, July 02, 2018 08:59
*To:* qgis-user@lists.osgeo.org
*Subject:* [EXTERNAL] Re: [Qgis-user] Not query geometry types in
layer browser?
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
<https://urldefense.proofpoint.com/v2/url?u=https-3A__docs.oracle.com_database_121_SPATL_constraining-2Ddata-2Dgeometry-2Dtype.htm-23SPATL584&d=DwMDaQ&c=M7nMI6M-Uv3ihEfN-QJ3_sQdVexoO64eU4Ftr4lnVk0&r=-89XSUoV_kZKlHf89FQGuyqPyUjA53juyA-7r7GoZVA&m=kMsobCS1r-dtfVBLfC8RZmbtJAznC8lfOANCQ5nwhA8&s=S9z0VtIEHJoE-2R25LFRmKsUNxZRFR9i7AgsQo4TRmc&e=>
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 <mailto:Qgis-user@lists.osgeo.org>
List info:https://lists.osgeo.org/mailman/listinfo/qgis-user
<https://urldefense.proofpoint.com/v2/url?u=https-3A__lists.osgeo.org_mailman_listinfo_qgis-2Duser&d=DwMDaQ&c=M7nMI6M-Uv3ihEfN-QJ3_sQdVexoO64eU4Ftr4lnVk0&r=-89XSUoV_kZKlHf89FQGuyqPyUjA53juyA-7r7GoZVA&m=kMsobCS1r-dtfVBLfC8RZmbtJAznC8lfOANCQ5nwhA8&s=caiUu-DvTuzd2TmfpjqNUppla10STsmQTtMQAtHX0Ig&e=>
Unsubscribe:https://lists.osgeo.org/mailman/listinfo/qgis-user
<https://urldefense.proofpoint.com/v2/url?u=https-3A__lists.osgeo.org_mailman_listinfo_qgis-2Duser&d=DwMDaQ&c=M7nMI6M-Uv3ihEfN-QJ3_sQdVexoO64eU4Ftr4lnVk0&r=-89XSUoV_kZKlHf89FQGuyqPyUjA53juyA-7r7GoZVA&m=kMsobCS1r-dtfVBLfC8RZmbtJAznC8lfOANCQ5nwhA8&s=caiUu-DvTuzd2TmfpjqNUppla10STsmQTtMQAtHX0Ig&e=>
--
*_Richard McDonnell_*
*GIS Specialist PgD GIS AssocSCSI*
*OPW FRM Data Management*
*52 Stephens Green, Dublin 2.*
TEL: 01 6476543
Image removed by sender.
<https://urldefense.proofpoint.com/v2/url?u=http-3A__www.opw.ie_&d=DwMDaQ&c=M7nMI6M-Uv3ihEfN-QJ3_sQdVexoO64eU4Ftr4lnVk0&r=-89XSUoV_kZKlHf89FQGuyqPyUjA53juyA-7r7GoZVA&m=kMsobCS1r-dtfVBLfC8RZmbtJAznC8lfOANCQ5nwhA8&s=C0r94_8VGOQDxvOdlZYMEBO-Vy0MTJzZdEdGu6Mpm8A&e=>
Email Disclaimer: http://www.opw.ie/en/disclaimer/
<https://urldefense.proofpoint.com/v2/url?u=http-3A__www.opw.ie_en_disclaimer_&d=DwMDaQ&c=M7nMI6M-Uv3ihEfN-QJ3_sQdVexoO64eU4Ftr4lnVk0&r=-89XSUoV_kZKlHf89FQGuyqPyUjA53juyA-7r7GoZVA&m=kMsobCS1r-dtfVBLfC8RZmbtJAznC8lfOANCQ5nwhA8&s=IA7mnpK0OpnLwBH204WtogeLT4aBNUz0C_yyA0Lm-AU&e=>
------------------------------------------------------------------------
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).
--
*_Richard McDonnell_*
*GIS Specialist PgD GIS AssocSCSI*
*OPW FRM Data Management*
*52 Stephens Green, Dublin 2.*
TEL: 01 6476543
_______________________________________________
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