[Qgis-user] WFS 2.18.1 slow with PostGIS layer

[Nicolas Boisteault]

Hi Régis,

No difference. In both case I have :

2016-11-29 12:17:05 CET [16843-1] login at host LOG:  statement: set 
client_encoding to 'UNICODE'
2016-11-29 12:17:05 CET [16843-2] login at host LOG:  statement: select 
regclass('pg_class')::oid
2016-11-29 12:17:05 CET [16843-3] login at host LOG:  statement: BEGIN
2016-11-29 12:17:05 CET [16843-4] login at host LOG:  statement: DECLARE 
oidcursor BINARY CURSOR FOR select regclass('pg_class')::oid
2016-11-29 12:17:05 CET [16843-5] login at host LOG:  statement: fetch 
forward 1 from oidcursor
2016-11-29 12:17:05 CET [16843-6] login at host LOG:  statement: CLOSE 
oidcursor
2016-11-29 12:17:05 CET [16843-7] login at host LOG:  statement: COMMIT
2016-11-29 12:17:05 CET [16843-8] login at host LOG:  statement: SELECT 
postgis_version()
2016-11-29 12:17:05 CET [16843-9] login at host LOG:  statement: SELECT 
postgis_geos_version(),postgis_proj_version()
2016-11-29 12:17:05 CET [16843-10] login at 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' )
2016-11-29 12:17:05 CET [16843-11] login at host LOG:  statement: SELECT 
oid FROM pg_catalog.pg_extension WHERE extname = 'pointcloud_postgis'
2016-11-29 12:17:05 CET [16843-12] login at host LOG:  statement: SET 
application_name='QGIS'
2016-11-29 12:17:05 CET [16843-13] login at host LOG:  statement: BEGIN 
READ ONLY
2016-11-29 12:17:05 CET [16843-14] login at host LOG:  statement: DECLARE 
qgis_1 BINARY CURSOR FOR SELECT "id","nom_scientifique"::text FROM 
"public"."especes"
2016-11-29 12:17:05 CET [16843-15] login at host LOG:  statement: FETCH 
FORWARD 2000 FROM qgis_1
2016-11-29 12:17:17 CET [16843-16] login at host LOG:  statement: FETCH 
FORWARD 2000 FROM qgis_1
2016-11-29 12:17:19 CET [16843-17] login at host LOG:  statement: CLOSE qgis_1
2016-11-29 12:17:19 CET [16843-18] login at host LOG:  statement: COMMIT

Thanks for your help.

Nicolas BOISTEAULT
Le 28/11/2016 à 19:13, Régis Haubourg a écrit :
> 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 
> <mailto: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
>     <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 <tel:05%2049%2049%2071%2018>
>     *Soyez Eco-responsable, n'imprimez que si nécessaire*
>
>     _______________________________________________
>     Qgis-user mailing list
>     Qgis-user at lists.osgeo.org <mailto:Qgis-user at lists.osgeo.org>
>     List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
>     <http://lists.osgeo.org/mailman/listinfo/qgis-user>
>     Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
>     <http://lists.osgeo.org/mailman/listinfo/qgis-user>
>
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20161129/ff1d1804/attachment.html>