Bug report #20908

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

Added by Georges Moes almost 2 years ago. Updated almost 2 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 2 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 2 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

(cherry picked from commit e3c1d18f3aaaab04adfec1af58419eb0419fb004)

History

#1 Updated by Nyall Dawson almost 2 years ago

  • Status changed from Open to Feedback

What filter are you using?

#2 Updated by Nyall Dawson almost 2 years ago

Actually ignore that - i can see the issue

#3 Updated by Nyall Dawson almost 2 years ago

  • Status changed from Feedback to Open

#4 Updated by Nyall Dawson almost 2 years ago

  • Status changed from Open to In Progress

#5 Updated by Nyall Dawson almost 2 years ago

  • % Done changed from 0 to 100
  • Status changed from In Progress to Closed

Also available in: Atom PDF