<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<p><font face="Helvetica, Arial, sans-serif">Hi, <br>
</font></p>
<p><font face="Helvetica, Arial, sans-serif">Indeed, 2.14.3 shows a
better performance with respect to serving database data, even
without yet tuning the database server.</font></p>
<p><font face="Helvetica, Arial, sans-serif">But, I still experience
some performance issues. One, I detected when using the print
composer, which is very unresponsive if there is a map object
with a big database layer and redrawing is needed (without
drawing the map, the UI responds fine). <br>
</font></p>
<p><font face="Helvetica, Arial, sans-serif">Second, the webclient
layers load in decent time, even the "big-one". But, trying to
use lizmap's "tooltip" feature on the big layer, or trying to
access its attribute table is still not possible. I haven't
checked the code, but maybe the way the data is being requested
in these situations is suboptimal?</font><br>
</p>
Regards<br>
<br>
<div class="moz-cite-prefix">El 21/06/16 a las 11:08, Daniel Vicente
Lühr Sierra escribió:<br>
</div>
<blockquote cite="mid:7b7c3085-5edf-2188-c604-fc2f1ba0f7fa@ieee.org"
type="cite">
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
<p><font face="Helvetica, Arial, sans-serif">Hi Régis,</font><br>
</p>
<br>
<div class="moz-cite-prefix">El 21/06/16 a las 10:37, Régis
Haubourg escribió:<br>
</div>
<blockquote
cite="mid:CABgOYCd5mCsoCa70ajhnbQZyDzJZna6EzzADn=KUftQkmzm4ww@mail.gmail.com"
type="cite">
<div dir="ltr">Hi,
<div>please see that thread [0]</div>
</div>
</blockquote>
Thanks.<br>
<blockquote
cite="mid:CABgOYCd5mCsoCa70ajhnbQZyDzJZna6EzzADn=KUftQkmzm4ww@mail.gmail.com"
type="cite">
<div dir="ltr">
<div>I suggest you first upgrade qgis server to last 2.14.3. <br>
</div>
</div>
</blockquote>
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.<br>
<blockquote
cite="mid:CABgOYCd5mCsoCa70ajhnbQZyDzJZna6EzzADn=KUftQkmzm4ww@mail.gmail.com"
type="cite">
<div dir="ltr">
<div>Then we still have issues with big relational views, not
tables - for first getcapabilities generation (ie first load
for a session). </div>
<div>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. <br>
</div>
</div>
</blockquote>
Ok. Although, I still need to learn how to do it ...<br>
<blockquote
cite="mid:CABgOYCd5mCsoCa70ajhnbQZyDzJZna6EzzADn=KUftQkmzm4ww@mail.gmail.com"
type="cite">
<div dir="ltr">
<div>Please keep us informed of how it works, we have the very
same concerns. <br>
</div>
</div>
</blockquote>
Sure, thanks again.<br>
<blockquote
cite="mid:CABgOYCd5mCsoCa70ajhnbQZyDzJZna6EzzADn=KUftQkmzm4ww@mail.gmail.com"
type="cite">
<div dir="ltr">
<div>[0] <a moz-do-not-send="true"
href="http://osgeo-org.1560.x6.nabble.com/Server-performance-questions-td5252233i20.html#a5268188">http://osgeo-org.1560.x6.nabble.com/Server-performance-questions-td5252233i20.html#a5268188</a></div>
</div>
<div class="gmail_extra"><br>
<div class="gmail_quote">2016-06-21 16:29 GMT+02:00 Daniel
Vicente Lühr Sierra <span dir="ltr"><<a
moz-do-not-send="true" class="moz-txt-link-abbreviated"
href="mailto:dluhr@ieee.org"><a class="moz-txt-link-abbreviated" href="mailto:dluhr@ieee.org">dluhr@ieee.org</a></a>></span>:<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
<div text="#000000" bgcolor="#FFFFFF">
<p><font face="Helvetica, Arial, sans-serif">Hi,</font></p>
<p><font face="Helvetica, Arial, sans-serif">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).</font></p>
<p>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).</p>
<p>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).</p>
<p>Any ideas on how to hunt down this performance issue?
May it be an issue with the web-client, also?</p>
<p>Btw, everything is running locally on a VM for now,
although the final deployment will be on "real"
hardware.<br>
</p>
Thanks<span class="HOEnZb"><font color="#888888"><br>
<pre cols="72">--
Daniel Vicente Lühr Sierra
IEEE Member
IEEE Student Branch Counselor - Universidad Austral de Chile
</pre>
</font></span></div>
<br>
_______________________________________________<br>
Qgis-user mailing list<br>
<a moz-do-not-send="true"
href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a><br>
List info: <a moz-do-not-send="true"
href="http://lists.osgeo.org/mailman/listinfo/qgis-user"
rel="noreferrer" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
Unsubscribe: <a moz-do-not-send="true"
href="http://lists.osgeo.org/mailman/listinfo/qgis-user"
rel="noreferrer" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
</blockquote>
</div>
<br>
<br clear="all">
<div><br>
</div>
-- <br>
<div class="gmail_signature" data-smartmail="gmail_signature">Régis
Haubourg<br>
<br>
Attention, changement d'adresse mail! <br>
Mon adresse principale devient désormais regis.haubourg at <a
moz-do-not-send="true" href="http://gmail.com"
target="_blank">gmail.com</a><br>
<br>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Qgis-user mailing list
<a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a>
List info: <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/qgis-user">http://lists.osgeo.org/mailman/listinfo/qgis-user</a>
Unsubscribe: <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/qgis-user">http://lists.osgeo.org/mailman/listinfo/qgis-user</a></pre>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
Daniel Vicente Lühr Sierra
IEEE Member
IEEE Student Branch Counselor - Universidad Austral de Chile
</pre>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
Daniel Vicente Lühr Sierra
IEEE Member
IEEE Student Branch Counselor - Universidad Austral de Chile
</pre>
</body>
</html>