[Qgis-user] (poor) performance loading postgis layers in qgis-server 2.8 ltr + postgis 2.1 + lizmap web-client

[Daniel Vicente Lühr Sierra]

Hi Régis,


El 21/06/16 a las 10:37, Régis Haubourg escribió:
> Hi, 
> please see that thread [0]
Thanks.
> I suggest you first upgrade qgis server to last 2.14.3.
Ok, some weeks ago I decided to stay with 2.8 ltr, until 2.14 was more
tested, it looks like it is time for upgrading.
> Then we still have issues with big relational views, not tables - for
> first getcapabilities generation (ie first load for a session). 
> You can also check your postgres logs to look at what queries are sent
> to PG and then tune your pg server based on those queries.
Ok. Although, I still need to learn how to do it ...
> Please keep us informed of how it works, we have the very same concerns.
Sure, thanks again.
> [0] http://osgeo-org.1560.x6.nabble.com/Server-performance-questions-td5252233i20.html#a5268188
>
> 2016-06-21 16:29 GMT+02:00 Daniel Vicente Lühr Sierra <dluhr at ieee.org
> <mailto:dluhr at ieee.org>>:
>
>     Hi,
>
>     It is my first time at setting up a postgres/PostGIS db for
>     storing "serious" data (previously, I had only tested if it
>     worked, with a couple of small data tables).
>
>     When testing the web-client (lizmap) installation I noticed that
>     the sample data loaded pretty fast, but when I tried a project
>     containing 2 vector layers stored in the database, one very small,
>     the second one was originally a ~30Mb shape file, the loading
>     process for the 2 layers is noticeable, and reading the attribute
>     table of the big vector layer (only 20 rows and 10 fields) takes
>     ages (actually, I wasn't able to wait for it to load).
>
>     I did some "google" research and found out that there might be
>     some performance issues on qgis-server when accessing postgresql
>     layer, or it could be that the performance of the db is low (I
>     haven't run the tuning utility, yet).
>
>     Any ideas on how to hunt down this performance issue? May it be an
>     issue with the web-client, also?
>
>     Btw, everything is running locally on a VM for now, although the
>     final deployment will be on "real" hardware.
>
>     Thanks
>
>     -- 
>     Daniel Vicente Lühr Sierra
>     IEEE Member
>     IEEE Student Branch Counselor - Universidad Austral de Chile
>
>
>     _______________________________________________
>     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
>     Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
>
>
>
>
> -- 
> Régis Haubourg
>
> Attention, changement d'adresse mail!
> Mon adresse principale devient désormais regis.haubourg at gmail.com
> <http://gmail.com>
>
>
>
> _______________________________________________
> 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

-- 
Daniel Vicente Lühr Sierra
IEEE Member
IEEE Student Branch Counselor - Universidad Austral de Chile

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