<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
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 class="moz-txt-link-freetext" href="https://docs.oracle.com/database/121/SPATL/constraining-data-geometry-type.htm#SPATL584">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>
<br>
<div class="moz-cite-prefix">On 02/07/2018 14:34, Bryan Hall wrote:<br>
</div>
<blockquote
cite="mid:CY4PR1101MB216766592F3FCD9C4ED41EE494430@CY4PR1101MB2167.namprd11.prod.outlook.com"
type="cite">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered
medium)">
<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;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
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;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;}
@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">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>
</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>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Qgis-user mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a>
List info: <a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/qgis-user">https://lists.osgeo.org/mailman/listinfo/qgis-user</a>
Unsubscribe: <a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/qgis-user">https://lists.osgeo.org/mailman/listinfo/qgis-user</a></pre>
</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>
<p>
<a href="http://www.opw.ie/"><img src="http://www.opw.ie/en/media/opw-logo-december-2016.gif" width="405" height="225" /></a>
</p>
<br /><br />Email Disclaimer: <a href="http://www.opw.ie/en/disclaimer/">http://www.opw.ie/en/disclaimer/</a>
</body>
</html>