<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<p>Hi Régis,</p>
<p>No difference. In both case I have :</p>
<p>2016-11-29 12:17:05 CET [16843-1] login@host LOG: statement: set
client_encoding to 'UNICODE'<br>
2016-11-29 12:17:05 CET [16843-2] login@host LOG: statement:
select regclass('pg_class')::oid<br>
2016-11-29 12:17:05 CET [16843-3] login@host LOG: statement:
BEGIN<br>
2016-11-29 12:17:05 CET [16843-4] login@host LOG: statement:
DECLARE oidcursor BINARY CURSOR FOR select
regclass('pg_class')::oid<br>
2016-11-29 12:17:05 CET [16843-5] login@host LOG: statement:
fetch forward 1 from oidcursor<br>
2016-11-29 12:17:05 CET [16843-6] login@host LOG: statement:
CLOSE oidcursor<br>
2016-11-29 12:17:05 CET [16843-7] login@host LOG: statement:
COMMIT<br>
2016-11-29 12:17:05 CET [16843-8] login@host LOG: statement:
SELECT postgis_version()<br>
2016-11-29 12:17:05 CET [16843-9] login@host LOG: statement:
SELECT postgis_geos_version(),postgis_proj_version()<br>
2016-11-29 12:17:05 CET [16843-10] login@host LOG: statement:
SELECT EXISTS ( SELECT c.oid FROM pg_class AS c JOIN pg_namespace
AS n ON c.relnamespace=n.oid WHERE n.nspname='topology' AND
c.relname='topology' )<br>
2016-11-29 12:17:05 CET [16843-11] login@host LOG: statement:
SELECT oid FROM pg_catalog.pg_extension WHERE extname =
'pointcloud_postgis'<br>
2016-11-29 12:17:05 CET [16843-12] login@host LOG: statement: SET
application_name='QGIS'<br>
2016-11-29 12:17:05 CET [16843-13] login@host LOG: statement:
BEGIN READ ONLY<br>
2016-11-29 12:17:05 CET [16843-14] login@host LOG: statement:
DECLARE qgis_1 BINARY CURSOR FOR SELECT
"id","nom_scientifique"::text FROM "public"."especes"<br>
2016-11-29 12:17:05 CET [16843-15] login@host LOG: statement:
FETCH FORWARD 2000 FROM qgis_1<br>
2016-11-29 12:17:17 CET [16843-16] login@host LOG: statement:
FETCH FORWARD 2000 FROM qgis_1<br>
2016-11-29 12:17:19 CET [16843-17] login@host LOG: statement:
CLOSE qgis_1<br>
2016-11-29 12:17:19 CET [16843-18] login@host LOG: statement:
COMMIT</p>
<p>Thanks for your help.<br>
</p>
<div class="moz-signature">
Nicolas BOISTEAULT<br>
<span style="color:#3E703F"></span></div>
<div class="moz-cite-prefix">Le 28/11/2016 à 19:13, Régis Haubourg a
écrit :<br>
</div>
<blockquote
cite="mid:CABgOYCfPYDCZnVB--zxfsHDWH8jpUJsDW5icSfh4Dy=c+NZL-Q@mail.gmail.com"
type="cite">
<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 moz-do-not-send="true"
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 moz-do-not-send="true"
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 moz-do-not-send="true"
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 moz-do-not-send="true"
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 moz-do-not-send="true"
href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a><br>
List info: <a moz-do-not-send="true"
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 moz-do-not-send="true"
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>
</blockquote>
<br>
</body>
</html>