Feature request #12926

Improve attribute table performance

Added by Paolo Cavallini over 7 years ago. Updated almost 5 years ago.

Category:Attribute table
Pull Request or Patch supplied:No Resolution:fixed/implemented
Easy fix?:No Copied to github as #:21008


Loading a large (pg) table requires the loading of all records. This is a real performance killer, and effectively prevents the use of layers with millions of records.
Moreover, even when selection Show only selected in Options, and selecting a few records, apparently all records are read, so this does not speed up.
This beaviour is changed from 1.8 to 2.0. In older versions if you show only selection or show only object visible in map extent qgis was faster. With newer version it has to read all the table data every time it is opened.
See also #10619

Related issues

Related to QGIS Application - Bug report #10619: Attribute table 'Show features visible on map' option doe... Closed 2014-06-18
Related to QGIS Application - Bug report #12318: attribute table does not show all features Closed 2015-03-05


#1 Updated by Jürgen Fischer over 7 years ago

  • Tracker changed from Bug report to Feature request
  • Subject changed from Loading attribute table very slow to Improve attribute table performance
  • Priority changed from Normal to High

#2 Updated by Alessandro Pasotti about 7 years ago

Here is an attempt to speed things up: https://github.com/qgis/QGIS/pull/2518

#3 Updated by Giovanni Manghi over 5 years ago

  • Easy fix? set to No

#4 Updated by Regis Haubourg over 5 years ago

  • Description updated (diff)
  • Status changed from Open to In Progress

Some work has been done here and seems to really improve things: [[https://github.com/qgis/QGIS/pull/4230]]

Some other improvements seem possible again with joined fields.

#5 Updated by Paolo Cavallini almost 5 years ago

  • Status changed from In Progress to Feedback

The two PR are closed. Should we close this as well?
Any automatic performance testing?

#6 Updated by Giovanni Manghi almost 5 years ago

  • Resolution set to fixed/implemented
  • Status changed from Feedback to Closed

Still slow for large tables if compared to other (gis) software. Better than in the past anyway.

Also available in: Atom PDF