[Qgis-user] Inefficient SQL

[Paul Wittle]

Hi,

We noticed that one of our users was accidentally sending inefficient (or possibly just massive) SQL statements to the Oracle database. I need to do more work to try and replicate the behaviour but is anyone familiar with how it can happen?

The query is in the form of select [statement] from table where ID = :a OR ID = :b ... OR ID = :xxab

We wondered why that would happen as normally you would just do a spatial query or perhaps do that for a small number of rows but it seemed to be doing it for a large number of rows.

Any tips to what might be the cause would help me to replicate the issue; my working theory is trying to load too many features in the attribute table but I'm not sure.

Thanks,

Paul Wittle
[cid:image001.jpg at 01D6513B.651ABDE0]<https://www.dorsetcouncil.gov.uk/>
Business Solutions Analyst (GIS)
ICT Operations
Dorset Council
01305 228473 <tel:01305%20228473%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20>
dorsetcouncil.gov.uk<https://www.dorsetcouncil.gov.uk>

[cid:image002.png at 01D6513B.651ABDE0]<https://www.facebook.com/DorsetCouncilUK>
[cid:image003.png at 01D6513B.651ABDE0]<https://instagram.com/DorsetCouncilUK>
[cid:image004.png at 01D6513B.651ABDE0]<https://twitter.com/DorsetCouncilUK>

This e-mail and any files transmitted with it are intended solely for the use of the individual or entity to whom they are addressed. It may contain unclassified but sensitive or protectively marked material and should be handled accordingly. Unless you are the named addressee (or authorised to receive it for the addressee) you may not copy or use it, or disclose it to anyone else. If you have received this transmission in error please notify the sender immediately. All traffic may be subject to recording and/or monitoring in accordance with relevant legislation. Any views expressed in this message are those of the individual sender, except where the sender specifies and with authority, states them to be the views of Dorset Council. Dorset Council does not accept service of documents by fax or other electronic means. Virus checking: Whilst all reasonable steps have been taken to ensure that this electronic communication and its attachments whether encoded, encrypted or otherwise supplied are free from computer viruses, Dorset Council accepts no liability in respect of any loss, cost, damage or expense suffered as a result of accessing this message or any of its attachments. For information on how Dorset Council processes your information, please see www.dorsetcouncil.gov.uk/416433
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20200703/91f9580f/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.jpg
Type: image/jpeg
Size: 4655 bytes
Desc: image001.jpg
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20200703/91f9580f/attachment-0001.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 2054 bytes
Desc: image002.png
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20200703/91f9580f/attachment-0003.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.png
Type: image/png
Size: 4476 bytes
Desc: image003.png
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20200703/91f9580f/attachment-0004.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image004.png
Type: image/png
Size: 1954 bytes
Desc: image004.png
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20200703/91f9580f/attachment-0005.png>