Feature request #12926

Improve attribute table performance

Added by Paolo Cavallini almost 5 years ago. Updated about 2 years ago.

Status:Closed
Priority:High
Assignee:-
Category:Attribute table
Pull Request or Patch supplied:No Resolution:fixed/implemented
Easy fix?:No Copied to github as #:21008

Description

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

History

#1 Updated by Jürgen Fischer almost 5 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 over 4 years ago

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

#3 Updated by Giovanni Manghi almost 3 years ago

  • Easy fix? set to No

#4 Updated by Regis Haubourg almost 3 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 about 2 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 about 2 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