<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p><font face="Helvetica, Arial, sans-serif">Hi,</font><br>
</p>
<br>
<div class="moz-cite-prefix">El 21/06/16 a las 10:35, Richard
McDonnell escribió:<br>
</div>
<blockquote cite="mid:576950B0.2080201@opw.ie" type="cite">
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
Hi Daniel,<br>
Ok, so the first thing I would ask, is have you Indexed the
geometry?<br>
</blockquote>
yes<br>
<blockquote cite="mid:576950B0.2080201@opw.ie" type="cite">
Secondly, If you are using any of the attributes for styling, I
would also advise using Indexing on those also.<br>
</blockquote>
Not used in the testing data, but I'll take note of this for other
situations.<br>
<blockquote cite="mid:576950B0.2080201@opw.ie" type="cite"> 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.<br>
</blockquote>
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.<br>
<br>
Thanks<br>
<blockquote cite="mid:576950B0.2080201@opw.ie" type="cite"> Hope
this helps,<br>
Regards,<br>
<br>
Richard.<br>
<br>
<br>
<br>
<div class="moz-cite-prefix">On 21/06/2016 15:29, Daniel Vicente
Lühr Sierra wrote:<br>
</div>
<blockquote
cite="mid:7a9bf82d-7856-7f91-e930-2ec3d05ccc0c@ieee.org"
type="cite">
<meta http-equiv="content-type" content="text/html;
charset=utf-8">
<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<br>
<pre class="moz-signature" cols="72">--
Daniel Vicente Lühr Sierra
IEEE Member
IEEE Student Branch Counselor - Universidad Austral de Chile
</pre>
<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>
<div class="moz-signature">-- <br>
<b><u>Richard McDonnell</u></b><br>
<b><small><small><small>GIS Specialist PgD GIS AssocSCSI</small></small></small></b><br>
<b><small>OPW FRM Data Management</small></b><br>
<b><small>52 Stephens Green, Dublin 2.</small></b><br>
<small><small>TEL: 01 6476543</small></small></div>
<!-- http://www.unicodetools.com/unicode/convert-to-html.php -->
<div style="font-family: Arial; font-size: 8pt;">
OPW - Ag féachaint don am atá le teacht - Ag caomhnú ón am atá
thart<br>
OPW - Looking to the future - Caring for the past<br>
<a moz-do-not-send="true" href="http://www.opw.ie/"><img
moz-do-not-send="true"
src="http://www.opw.ie/en/media/opw-email-banner.png"
height="76" width="494"></a><br>
Email Disclaimer: <a moz-do-not-send="true"
href="http://www.opw.ie/en/disclaimer/">http://www.opw.ie/en/disclaimer/</a>
</div>
</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>