<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Bryan,<br>
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.<br>
<br>
The only other way I know, which is quicker for loading Tables (if
you have already added them as sources) would be to:<br>
<br>
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!<br>
<br>
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.<br>
Hope it helps, Regards,<br>
<br>
Richard.<br>
<br>
<div class="moz-cite-prefix">On 02/07/2018 17:03, Bryan Hall wrote:<br>
</div>
<blockquote
cite="mid:CY4PR1101MB2167DBB26214032B9306A4A994430@CY4PR1101MB2167.namprd11.prod.outlook.com"
type="cite">
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
<meta name="Generator" content="Microsoft Word 15 (filtered
medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]-->
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
color:black;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
pre
{mso-style-priority:99;
mso-style-link:"HTML Preformatted Char";
margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";
color:black;}
span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:Consolas;
color:black;}
p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
color:black;}
p.msipheader9d2ba7ab, li.msipheader9d2ba7ab, div.msipheader9d2ba7ab
{mso-style-name:msipheader9d2ba7ab;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
color:black;}
span.EmailStyle21
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.EmailStyle22
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
<p class="msipheader9d2ba7ab" align="Center"><span
style="font-size:8.0pt;font-family:Calibri;color:#0078D7">Classification:
DCL-Internal</span></p>
<br>
<br>
<div class="WordSection1">
<p class="MsoNormal"><span style="color:windowtext">Richard,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:windowtext"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:windowtext">Yes, I
understand how to do that, and this is not the issue.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:windowtext"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:windowtext">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).<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:windowtext"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:windowtext">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.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:windowtext"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:windowtext">Bryan<o:p></o:p></span></p>
<p class="MsoNormal"><a moz-do-not-send="true"
name="_MailEndCompose"><span style="color:windowtext"><o:p> </o:p></span></a></p>
<span style="mso-bookmark:_MailEndCompose"></span>
<div>
<div style="border:none;border-top:solid #E1E1E1
1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b><span style="color:windowtext">From:</span></b><span
style="color:windowtext"> Qgis-user
[<a class="moz-txt-link-freetext" href="mailto:qgis-user-bounces@lists.osgeo.org">mailto:qgis-user-bounces@lists.osgeo.org</a>]
<b>On Behalf Of </b>Richard McDonnell<br>
<b>Sent:</b> Monday, July 02, 2018 08:59<br>
<b>To:</b> <a class="moz-txt-link-abbreviated" href="mailto:qgis-user@lists.osgeo.org">qgis-user@lists.osgeo.org</a><br>
<b>Subject:</b> [EXTERNAL] Re: [Qgis-user] Not query
geometry types in layer browser?<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal" style="margin-bottom:12.0pt">Hi, <br>
If I understand your question correctly.<br>
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.<br>
A quick search online resulted in<br>
<br>
<a moz-do-not-send="true"
href="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=">https://docs.oracle.com/database/121/SPATL/constraining-data-geometry-type.htm#SPATL584</a><br>
<br>
Hope this helps!<br>
Regards,<br>
<br>
Richard.<br>
<br>
<o:p></o:p></p>
<div>
<p class="MsoNormal">On 02/07/2018 14:34, Bryan Hall wrote:<o:p></o:p></p>
</div>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<p class="msipheader9d2ba7ab" style="text-align:center"
align="center"><span style="font-size:8.0pt;color:#0078D7">Classification:
DCL-Internal</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-bottom:12.0pt"><o:p> </o:p></p>
<p class="MsoNormal">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?<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">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.<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">Thanks in advance,<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">Bryan<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div class="MsoNormal" style="text-align:center"
align="center">
<hr align="center" size="2" width="100%">
</div>
<p class="MsoNormal"><span
style="font-size:7.5pt;font-family:"Arial",sans-serif;color:gray"><br>
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).</span>
<br>
<br>
<br>
<o:p></o:p></p>
<pre>_______________________________________________<o:p></o:p></pre>
<pre>Qgis-user mailing list<o:p></o:p></pre>
<pre><a moz-do-not-send="true" href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a><o:p></o:p></pre>
<pre>List info: <a moz-do-not-send="true" href="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=">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><o:p></o:p></pre>
<pre>Unsubscribe: <a moz-do-not-send="true" href="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=">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><o:p></o:p></pre>
</blockquote>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal">-- <br>
<b><u>Richard McDonnell</u></b><br>
<b><span style="font-size:7.5pt">GIS Specialist PgD GIS
AssocSCSI</span></b><br>
<b><span style="font-size:7.5pt">OPW FRM Data Management</span></b><br>
<b><span style="font-size:7.5pt">52 Stephens Green, Dublin
2.</span></b><br>
<span style="font-size:7.5pt">TEL: 01 6476543</span><o:p></o:p></p>
</div>
<p><a moz-do-not-send="true"
href="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="><span
style="border:solid windowtext
1.0pt;padding:0in;text-decoration:none"><img
style="width:4.2187in;height:2.3437in"
id="Picture_x0020_2"
src="cid:part6.09030101.02070008@opw.ie" alt="Image
removed by sender." border="0" height="225" width="405"></span></a><o:p></o:p></p>
<p class="MsoNormal"><br>
<br>
Email Disclaimer: <a moz-do-not-send="true"
href="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=">http://www.opw.ie/en/disclaimer/</a>
<o:p></o:p></p>
</div>
<br>
<hr>
<font color="Gray" size="1" face="Arial"><br>
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).</font>
</blockquote>
<br>
<div class="moz-signature">-- <br>
<b><u>Richard McDonnell</u></b><br>
<b><small><small><small>GIS Specialist PgD GIS AssocSCSI</small></small></small></b><br>
<b><small>OPW FRM Data Management</small></b><br>
<b><small>52 Stephens Green, Dublin 2.</small></b><br>
<small><small>TEL: 01 6476543</small></small></div>
</body>
</html>