[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,


El 21/06/16 a las 10:35, Richard McDonnell escribió:
> Hi Daniel,
> Ok, so the first thing I would ask, is have you Indexed the geometry?
yes
> Secondly, If you are using any of the attributes for styling, I would
> also advise using Indexing on those also.
Not used in the testing data, but I'll take note of this for other
situations.
> Thirdly Zoom Levels, do you need to show all the data when zoomed out
> fully? If not, you can create zoom levels in your styling which can
> minimise the amount of geometry shown, speeding up draw time.
Ok, I didn't even dare zooming (in or out), but the default extent is a
zoomed in portion of the "big" layer (~1/15 of the total surface). I'll
check this.

Thanks
> Hope this helps,
> Regards,
>
> Richard.
>
>
>
> On 21/06/2016 15:29, Daniel Vicente Lühr Sierra wrote:
>>
>> 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
>> List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
>> Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
>
> -- 
> *_Richard McDonnell_*
> *GIS Specialist PgD GIS AssocSCSI*
> *OPW FRM Data Management*
> *52 Stephens Green, Dublin 2.*
> TEL: 01 6476543
> OPW - Ag féachaint don am atá le teacht - Ag caomhnú ón am atá thart
> OPW - Looking to the future - Caring for the past
> <http://www.opw.ie/>
> Email Disclaimer: http://www.opw.ie/en/disclaimer/

-- 
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/d5e1c82c/attachment.html>