[Qgis-user] Not query geometry types in layer browser?

[Richard McDonnell]

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 at 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/

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20180702/11f107be/attachment.html>