[QGIS-Developer] QGIS 2.18.x Attribute Table Performance

Ted tiruchirapalli at gmail.com
Thu May 25 19:07:31 PDT 2017


Hi,

I'm facing a HIGHLY DEGRADED performance with attribute table opening with
version 2.18.x (2.18.8 and 2.18.7) when we have more than 100K rows. (in
this case 161K)

I'm looking at an OLD application done 5 years back with a custom QGIS 1.7,
PostgreSQL 9.0 and PostGIS.

The performance at that time was high commendable and it worked very well.
See the video here;
https://www.youtube.com/watch?v=3rjeqgFK5GA
(this video was taken on a Virtual Machine)

Recently we stepped into upgrade the technology stack and to my surprise,
the current version of QGIS 2.18.8 is way TOO slow and this goes all
against the QGIS in the Government environment.

While keeping the DB on the VM environment, we tested it on different
platform and version;

QGIS 2.18.8 (latest) ruining on Windows 10 environment
https://www.youtube.com/watch?v=k19tEqSK-1Y&t=64s
Took nearly 2 minutes to open !!!

QGIS 2.18.7 ruining on MacOS environment
https://www.youtube.com/watch?v=S1eg2K17Z1E&t=15s
Again took more than 2 minutes to open !!!

QGIS 2.14.14 (LTR) ruining on MacOS environment
https://www.youtube.com/watch?v=Sv-qklLFCHA
Took only 5 seconds to open :)


So, it appears that something has gone SERIOUSLY WRONG between the version
2.14.x and 2.18.x

Since 2.18.x is marked as LTR version, I really hope this issue is fixed
since most of the government environments adopt only the LTR version and
with such performance it goes against QGIS.

The next LTR is 3.2 which is more than a year later. Can you please look
into this issue?

Thanks and Cheers !


Ted
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20170526/b41efc13/attachment.html>


More information about the QGIS-Developer mailing list