Bug report #15904

WFS 2.18.1 slow with PostGIS layer

Added by Nicolas Boisteault over 7 years ago. Updated over 5 years ago.

Category:QGIS Server
Affected QGIS version:2.18.0 Regression?:No
Operating System: Easy fix?:No
Pull Request or Patch supplied:No Resolution:fixed/implemented
Crashes QGIS or corrupts data:No Copied to github as #:23821


OS : Ubuntu Server 16.04
QGIS Server : 2.18.1
PostgreSQL : 9.6
PostGIS : 2.3

In my projet I have a layer with about 2500 rows, 2 columns and no geometry.
If I wget the WFS :

time wget -pq --no-cache --delete-after ""

Result with QGIS 2.14.9 :

real 0m0.379s
user 0m0.003s
sys 0m0.002s

Now with QGIS 2.18.1 :

real 0m13.438s
user 0m0.001s
sys 0m0.007s

As you can see, it is very very slow.


#1 Updated by Giovanni Manghi almost 7 years ago

  • Easy fix? set to No
  • Regression? set to No

#2 Updated by Jürgen Fischer over 6 years ago

  • Category set to Unknown

#3 Updated by Even Rouault almost 6 years ago

  • Description updated (diff)
  • Category changed from Unknown to QGIS Server

#4 Updated by Nicolas Boisteault over 5 years ago

  • Status changed from Open to Closed

I can't reproduce the issue in QGIS 2.18.24. Good work developers!

#5 Updated by Giovanni Manghi over 5 years ago

  • Resolution set to fixed/implemented

Also available in: Atom PDF