Hi Paul,
Not sure what causes this in QGIS, but I can imagine this happens when
you need data for a manual selection. So you select 200 features on your
screen (by dragging a box) and then export them to a file? Or maybe QGIS
does this better but a plugin doesn't?
To add to this, I remember hitting a "maximum where clauses of 1000" in
Oracle a while ago, so this doesn't only affect performance but can
cause errors as well.
Regards,
Raymond
On 03-07-2020 14:11, Paul Wittle wrote:
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 *
<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>
<https://www.facebook.com/DorsetCouncilUK>
<https://instagram.com/DorsetCouncilUK>
<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
_______________________________________________
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
_______________________________________________
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user