Re: [Qgis-user] Inefficient SQL

2020-07-03 Thread chris hermansen
Paul and list, On Fri, Jul 3, 2020, 05: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

Re: [Qgis-user] Inefficient SQL

2020-07-03 Thread Raymond Nijssen
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

[Qgis-user] Inefficient SQL

2020-07-03 Thread 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]