Bug report #15904
Updated by Even Rouault over 6 years ago
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.
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.