<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<p>Hi list,</p>
<p>OS : Ubuntu Server 16.04<br>
QGIS Server : 2.18.1<br>
PostgreSQL : 9.6.1<br>
PostGIS : 2.3<br>
<br>
In my project I have a layer with about 2500 rows, 2 columns and
no geometry.<br>
If I wget the WFS :<br>
<br>
time wget -pq --no-cache --delete-after
<a class="moz-txt-link-rfc2396E" href="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">"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"</a><br>
<br>
Result with QGIS 2.14.9 :<br>
<br>
real 0m0.379s<br>
user 0m0.003s<br>
sys 0m0.002s<br>
<br>
Now with QGIS 2.18.1 :<br>
<br>
real 0m13.438s<br>
user 0m0.001s<br>
sys 0m0.007s<br>
<br>
As you can see, it is very very slow. Has someone the same issue?<br>
</p>
<p>I opened a ticket here : <a class="moz-txt-link-freetext" href="http://hub.qgis.org/issues/15904">http://hub.qgis.org/issues/15904</a><br>
</p>
<br>
<div class="moz-signature">-- <br>
Nicolas BOISTEAULT<br>
Développeur Web/WebSIG<br>
Observatoire Régional de l'Environnement<br>
Téléport 4 Antarès - BP 50163 - 86962 Futuroscope Chasseneuil
Cedex<br>
Tél : 05 49 49 71 18<br>
<span style="color:#3E703F"><b>Soyez Eco-responsable, n'imprimez
que si nécessaire</b></span></div>
</body>
</html>