<div dir="ltr">Hi Nicolas, <div>If you look at the postgres logs, is there anything different? </div><div>Cheers, </div><div>Régis</div></div><div class="gmail_extra"><br><div class="gmail_quote">2016-11-28 18:29 GMT+01:00 Nicolas Boisteault <span dir="ltr"><<a href="mailto:boisteault@observatoire-environnement.org" target="_blank">boisteault@observatoire-environnement.org</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div 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="m_-2532887313947026699moz-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" target="_blank">"http://127.0.0.1/cgi-bin/<wbr>qgis_mapserv.fcgi?SERVICE=WFS&<wbr>VERSION=1.0.0&REQUEST=<wbr>GetFeature&TYPENAME=especes&<wbr>PROPERTYNAME=nom_scientifique%<wbr>2Cid&OUTPUTFORMAT=GeoJSON&<wbr>GEOMETRYNAME=none&map=path_to_<wbr>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="m_-2532887313947026699moz-txt-link-freetext" href="http://hub.qgis.org/issues/15904" target="_blank">http://hub.qgis.org/issues/<wbr>15904</a><span class="HOEnZb"><font color="#888888"><br>
</font></span></p><span class="HOEnZb"><font color="#888888">
<br>
<div class="m_-2532887313947026699moz-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 : <a href="tel:05%2049%2049%2071%2018" value="+33549497118" target="_blank">05 49 49 71 18</a><br>
<span style="color:#3e703f"><b>Soyez Eco-responsable, n'imprimez
que si nécessaire</b></span></div>
</font></span></div>
<br>______________________________<wbr>_________________<br>
Qgis-user mailing list<br>
<a href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a><br>
List info: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noreferrer" target="_blank">http://lists.osgeo.org/<wbr>mailman/listinfo/qgis-user</a><br>
Unsubscribe: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noreferrer" target="_blank">http://lists.osgeo.org/<wbr>mailman/listinfo/qgis-user</a><br></blockquote></div><br></div>