WFS 2.18.1 slow with PostGIS layer

[qgib]

Author Name: Nicolas Boisteault (@nboisteault)
Original Redmine Issue: 15904
Affected QGIS version: 2.18.0
Redmine category:qgis_server

---

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 "http://127.0.0.1/cgi-bin/qgis_mapserv.fcgi?SERVICE=WFS&VERSION=1.0.0&REQUEST=GetFeature&TYPENAME=especes&PROPERTYNAME=nom_scientifique%2Cid&OUTPUTFORMAT=GeoJSON&GEOMETRYNAME=none&map=path_to_my_project.qgs"

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.

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

• easy_fix was configured as 0
• regression was configured as 0

[qgib]

Author Name: Jürgen Fischer (@jef-n)

---

• category_id was configured as Unknown

[qgib]

Author Name: Even Rouault (@rouault)

---

• description was changed from 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 "http://127.0.0.1/cgi-bin/qgis_mapserv.fcgi?SERVICE=WFS&VERSION=1.0.0&REQUEST=GetFeature&TYPENAME=especes&PROPERTYNAME=nom_scientifique%2Cid&OUTPUTFORMAT=GeoJSON&GEOMETRYNAME=none&map=path_to_my_project.qgs"

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.
to 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 "http://127.0.0.1/cgi-bin/qgis_mapserv.fcgi?SERVICE=WFS&VERSION=1.0.0&REQUEST=GetFeature&TYPENAME=especes&PROPERTYNAME=nom_scientifique%2Cid&OUTPUTFORMAT=GeoJSON&GEOMETRYNAME=none&map=path_to_my_project.qgs"

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.

• category_id was changed from Unknown to QGIS Server

[qgib]

Author Name: Nicolas Boisteault (@nboisteault)

---

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

---

• status_id was changed from Open to Closed

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

• resolution was changed from to fixed/implemented