[Qgis-user] WFS 2.18.1 slow with PostGIS layer

[Nicolas Boisteault]

Hi list,

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

In my project 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. Has someone the same issue?

I opened a ticket here : http://hub.qgis.org/issues/15904


-- 
Nicolas BOISTEAULT
Développeur Web/WebSIG
Observatoire Régional de l'Environnement
Téléport 4 Antarès - BP 50163 - 86962 Futuroscope Chasseneuil Cedex
Tél : 05 49 49 71 18
*Soyez Eco-responsable, n'imprimez que si nécessaire*
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20161128/c1276db9/attachment.html>