Re: [Qgis-user] WFS 2.18.1 slow with PostGIS layer

Tue, 29 Nov 2016 03:29:25 -0800 

Hi Régis,

No difference. In both case I have :
2016-11-29 12:17:05 CET [16843-1] login@host LOG: statement: set client_encoding to 'UNICODE' 2016-11-29 12:17:05 CET [16843-2] login@host LOG: statement: select regclass('pg_class')::oid 
2016-11-29 12:17:05 CET [16843-3] login@host LOG:  statement: BEGIN
2016-11-29 12:17:05 CET [16843-4] login@host LOG: statement: DECLARE oidcursor BINARY CURSOR FOR select regclass('pg_class')::oid 2016-11-29 12:17:05 CET [16843-5] login@host LOG: statement: fetch forward 1 from oidcursor 2016-11-29 12:17:05 CET [16843-6] login@host LOG: statement: CLOSE oidcursor 
2016-11-29 12:17:05 CET [16843-7] login@host LOG:  statement: COMMIT
2016-11-29 12:17:05 CET [16843-8] login@host LOG: statement: SELECT postgis_version() 2016-11-29 12:17:05 CET [16843-9] login@host LOG: statement: SELECT postgis_geos_version(),postgis_proj_version() 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' ) 2016-11-29 12:17:05 CET [16843-11] login@host LOG: statement: SELECT oid FROM pg_catalog.pg_extension WHERE extname = 'pointcloud_postgis' 2016-11-29 12:17:05 CET [16843-12] login@host LOG: statement: SET application_name='QGIS' 2016-11-29 12:17:05 CET [16843-13] login@host LOG: statement: BEGIN READ ONLY 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" 2016-11-29 12:17:05 CET [16843-15] login@host LOG: statement: FETCH FORWARD 2000 FROM qgis_1 2016-11-29 12:17:17 CET [16843-16] login@host LOG: statement: FETCH FORWARD 2000 FROM qgis_1 
2016-11-29 12:17:19 CET [16843-17] login@host LOG:  statement: CLOSE qgis_1
2016-11-29 12:17:19 CET [16843-18] login@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 <boistea...@observatoire-environnement.org <mailto:boistea...@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@lists.osgeo.org <mailto:Qgis-user@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>





_______________________________________________
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

Reply via email to