Bug report #20908: Print composer attributes from PostGis seems to slow down extremly the loading of project files - QGIS Application - QGIS Issue Tracking

Bug report #20908

Print composer attributes from PostGis seems to slow down extremly the loading of project files

Added by Georges Moes almost 6 years ago. Updated almost 6 years ago.

Status:	Closed
Priority:	Normal
Assignee:	-
Category:	Data Provider/PostGIS
Affected QGIS version:	3.4.3	Regression?:	No
Operating System:	macos / Windows 10	Easy fix?:	No
Pull Request or Patch supplied:	No	Resolution:
Crashes QGIS or corrupts data:	No	Copied to github as #:	28727

Description

My projects take extremly long to get loaded (from 4-10 mins). Working on macOS (10.14.2 but even earlier releases chowed the same behavior) with QGis 3.4.3, but on 2.18 I encounter the same probs. I could reproduce a similar behavior on Windows 10.
Today I've tested a few things.
Without any declared printcomposition my project loads in 5-10 sec.
This stays the same as long as I don't add a table with attributes.
When I add an attributes table to the print composer which comes from a PostGis-Server (I apply a filterimg to them to reduce the amount of datasets),
my whole project takes incredible long to get loaded (up to 10 mins).

Associated revisions

Revision e3c1d18f
Added by Nyall Dawson almost 6 years ago

[layouts] Fix inefficient filtering in attribute tables

Set the expression filter on the request itself, rather than looping
through all features and testing on the filter. This allows providers
to hand off the filtering to the underlying datasource, and utilise
indices/etc where available.

Fixes #20908

Revision cf410407
Added by Nyall Dawson almost 6 years ago

[layouts] Fix inefficient filtering in attribute tables

Fixes #20908

(cherry picked from commit e3c1d18f3aaaab04adfec1af58419eb0419fb004)