<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:"Trebuchet MS";
panose-1:2 11 6 3 2 2 2 2 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Trebuchet MS",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:3.0cm 2.0cm 3.0cm 2.0cm;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="en-DK" link="#0563C1" vlink="#954F72" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal"><span lang="DA" style="font-size:10.0pt;font-family:"Trebuchet MS",sans-serif">Hi again,<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="DA" style="font-size:10.0pt;font-family:"Trebuchet MS",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:"Trebuchet MS",sans-serif">On our quest for better performance mentioned below we have used the debugging/development tools panel to monitor startup and project load time.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:"Trebuchet MS",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:"Trebuchet MS",sans-serif">Here we on several occasions have noted a fair amount of time spent on ‘Reading external settings’ (up to 17 sec) during project load. Does anybody know the
exact processes going on during this?? Exactly what external settings are being read?<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:"Trebuchet MS",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:"Trebuchet MS",sans-serif">Thanks in advance!<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Trebuchet MS",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Trebuchet MS",sans-serif;color:#404040;mso-fareast-language:#2000"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:"Trebuchet MS",sans-serif;color:#404040;mso-fareast-language:#2000">Kind regards,</span><span style="font-size:10.0pt;font-family:"Trebuchet MS",sans-serif;color:#404040;mso-fareast-language:#2000"><br>
<br>
</span><b><span style="font-family:"Trebuchet MS",sans-serif;color:#404040;mso-fareast-language:#2000">Morten Storm<br>
</span></b><span style="font-size:10.0pt;font-family:"Trebuchet MS",sans-serif;color:#404040;mso-fareast-language:#2000">Chefkonsulent</span><span style="mso-fareast-language:#2000">
<br>
<br>
</span><a href="http://www.artogis.dk/"><span lang="DA" style="color:windowtext;text-decoration:none"><img border="0" width="211" height="32" style="width:2.1979in;height:.3333in" id="Billede_x0020_3" src="cid:image001.png@01D798CC.F9FD33F0"></span></a><span style="mso-fareast-language:#2000"><br>
</span><span lang="DA"><img border="0" width="208" height="52" style="width:2.1666in;height:.5416in" id="Billede_x0020_4" src="cid:image002.png@01D798CC.F9FD33F0"></span><span style="font-size:10.0pt;font-family:"Trebuchet MS",sans-serif"><o:p></o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span lang="DA" style="mso-fareast-language:#2000">Fra:</span></b><span lang="DA" style="mso-fareast-language:#2000"> Qgis-user <qgis-user-bounces@lists.osgeo.org>
<b>På vegne af </b>Morten Storm<br>
<b>Sendt:</b> 23. august 2021 10:05<br>
<b>Til:</b> qgis-user@lists.osgeo.org<br>
<b>Emne:</b> [Qgis-user] QGIS slow performance with PostgreSQL/PostGIS<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Trebuchet MS",sans-serif">We experience slow performance in QGIS 3.xx (also tried with 3.20 with no noticable improvement). Data are stored in a PostgreSQL/PostGIS database and we have done enough
testing that we do not believe that the database is the problem. </span><span lang="EN-US" style="font-size:10.0pt;font-family:"Trebuchet MS",sans-serif">And all tables are setup with spatial indexes and attribute indexes on fields used for filtering and visualization.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Trebuchet MS",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Trebuchet MS",sans-serif">The slowness shows its ugly face when for instance the program freezes for a long time when performing even simple tasks, like e.g. saving the project or moving the map
in the window.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Trebuchet MS",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Trebuchet MS",sans-serif">The issue increases with the size of the project and we don't experience any noticable slowness in small to medium sized projects. The project I tested with most recently
was about 4-5 MB when saved in QGIS 3 format (qgz) and about 40 MB when saved unzipped (qgs).<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Trebuchet MS",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Trebuchet MS",sans-serif">The project contains perhaps +/-100 vector layers from PostgreSQL/PostGIS data and a few online layers (basemap, etc.). Has anybody encountered anything similar and perhaps
even found the reason and a solution? Or is anybody aware of some <b>software that could help debug/analyze QGIS</b> to find out what takes all that ti</span><span lang="EN-US" style="font-size:10.0pt;font-family:"Trebuchet MS",sans-serif">m</span><span style="font-size:10.0pt;font-family:"Trebuchet MS",sans-serif">e?<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Trebuchet MS",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Trebuchet MS",sans-serif">As implied earlier we have tried and tested a lot including running QGIS on the same physical server as the database to eliminate network issues.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Trebuchet MS",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Trebuchet MS",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:"Trebuchet MS",sans-serif">Kind regards,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Trebuchet MS",sans-serif;color:#404040;mso-fareast-language:#2000"><br>
</span><b><span style="font-family:"Trebuchet MS",sans-serif;color:#404040;mso-fareast-language:#2000">Morten Storm<br>
</span></b><span style="font-size:10.0pt;font-family:"Trebuchet MS",sans-serif;color:#404040;mso-fareast-language:#2000">Chefkonsulent</span><span style="mso-fareast-language:#2000">
<br>
<br>
</span><a href="http://www.artogis.dk/"><span lang="DA" style="color:windowtext;text-decoration:none"><img border="0" width="211" height="32" style="width:2.1979in;height:.3333in" id="Billede_x0020_1" src="cid:image001.png@01D798CC.F9FD33F0"></span></a><span style="mso-fareast-language:#2000"><br>
</span><span lang="DA"><img border="0" width="208" height="52" style="width:2.1666in;height:.5416in" id="Billede_x0020_2" src="cid:image002.png@01D798CC.F9FD33F0"></span><o:p></o:p></p>
</div>
</body>
</html>