[Qgis-user] WFS 2.18.1 slow with PostGIS layer

[Régis Haubourg]

Hi Nicolas,
If you look at the postgres logs, is there anything different?
Cheers,
Régis

2016-11-28 18:29 GMT+01:00 Nicolas Boisteault <
boisteault at observatoire-environnement.org>:

> 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"
> <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*
>
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20161128/a29684cd/attachment.html>