Feature request #12926
Improve attribute table performance
| 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
History
#1
Updated by Jürgen Fischer over 9 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 almost 9 years ago
Here is an attempt to speed things up: https://github.com/qgis/QGIS/pull/2518
#3
Updated by Giovanni Manghi over 7 years ago
- Easy fix? set to No
#4
Updated by Regis Haubourg over 7 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 over 6 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 over 6 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.