<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<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]-->
</head>
<body bgcolor="white" lang="EN-US" link="#0563C1" vlink="#954F72">
<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 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 [mailto:qgis-user-bounces@lists.osgeo.org]
<b>On Behalf Of </b>Richard McDonnell<br>
<b>Sent:</b> Monday, July 02, 2018 08:59<br>
<b>To:</b> qgis-user@lists.osgeo.org<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 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" align="center" style="text-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" align="center" style="text-align:center">
<hr size="2" width="100%" align="center">
</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 href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a><o:p></o:p></pre>
<pre>List info: <a 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 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 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 border="0" width="405" height="225" style="width:4.2187in;height:2.3437in" id="Picture_x0020_2" src="cid:image001.jpg@01D411F4.4B3ABCA0" alt="Image removed by sender."></span></a><o:p></o:p></p>
<p class="MsoNormal"><br>
<br>
Email Disclaimer: <a 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 face="Arial" color="Gray" size="1"><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>
</body>
</html>