[Qgis-user] issues DB manager and qgis3.16.1
Raymond Nijssen
r.nijssen at terglobo.nl
Wed Dec 16 14:14:28 PST 2020
Hi Jeroen,
I can confirm this slow behaviour.
I tried a select * with the DB-manager on a point table with almost 300k
records:
QGIS 3.10: 0.35 sec
QGIS 3.17: 6.9 sec
Kind regards,
Raymond
On 15-12-2020 13:28, Groene Bij wrote:
> Hi all,
>
> I just downloaded qgis 3.16.1 (win64) and installed it next to my
> existing qgis 3.10.4
>
> I went ahead and did some work in DB manager and immediately notices a
> slow response. Simple select queries which take about 0.004 sec in
> qgis3.10.4 now take .4 sec in qgis 3.16.1
>
> Also, when viewing data in the table-tab in DB manager something weird
> happens: data gets repeated. The primary key column (gid) should contain
> and does contain unique values.
>
> However, in the table-tab view some rows are repeated, so for instance,
> row 106 shows gid = 101 and the corresponding values for the other
> columns. Then, scrolling down row 206 also shows gid = 101 and the
> corresponding values for the other columns (corresponding tot gid=101)
>
> This example containing row 106 and 206 is just a coincidence, it is not
> that it repeats after 100 rows. Multiple rows are copied, just by
> scrolling up and down I notice several different gid values being copied.
>
> Furthermore the result is consistent when closing qgis and reopening
> it. Select the same table and it is again row 106 and row 206 that will
> show gid = 101
>
> Doing the same in qgis 3.10.4 does not show this error. In qgis 3.10.4
> row 106 shows gid = 101 and row 206 shows gid = 205
>
> So there seems to be something going on with db manager and qgis3.16.1,
> but I have no idea what it could be.
>
> Kind regards,
>
> Jeroen
>
>
> _______________________________________________
> 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
>
More information about the Qgis-user
mailing list