<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<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:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@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:Aptos;}
@font-face
{font-family:"Segoe UI";
panose-1:2 11 5 2 4 2 4 2 2 3;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
font-size:11.0pt;
font-family:"Aptos",sans-serif;
mso-ligatures:standardcontextual;
mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#467886;
text-decoration:underline;}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
{mso-style-priority:34;
margin-top:0cm;
margin-right:0cm;
margin-bottom:0cm;
margin-left:36.0pt;
font-size:11.0pt;
font-family:"Aptos",sans-serif;
mso-ligatures:standardcontextual;
mso-fareast-language:EN-US;}
span.EmailStyle22
{mso-style-type:personal-reply;
font-family:"Aptos",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;
mso-ligatures:none;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
/* List Definitions */
@list l0
{mso-list-id:395592966;
mso-list-type:hybrid;
mso-list-template-ids:1384835308 403243009 403243011 403243013 403243009 403243011 403243013 403243009 403243011 403243013;}
@list l0:level1
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Symbol;}
@list l0:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:"Courier New";}
@list l0:level3
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Wingdings;}
@list l0:level4
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Symbol;}
@list l0:level5
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:"Courier New";}
@list l0:level6
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Wingdings;}
@list l0:level7
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Symbol;}
@list l0:level8
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:"Courier New";}
@list l0:level9
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Wingdings;}
ol
{margin-bottom:0cm;}
ul
{margin-bottom:0cm;}
--></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-PH" link="#467886" vlink="#96607D" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal">Hi Richard,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Thank you so much for the fast response! We will try this and will keep you guys posted.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Have a great day!<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Regards,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">-Aaron<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span lang="EN-US" style="font-family:"Calibri",sans-serif;mso-ligatures:none;mso-fareast-language:EN-PH">From:</span></b><span lang="EN-US" style="font-family:"Calibri",sans-serif;mso-ligatures:none;mso-fareast-language:EN-PH"> Richard
McDonnell <richard.mcdonnell@opw.ie> <br>
<b>Sent:</b> Tuesday, June 18, 2024 9:18 AM<br>
<b>To:</b> Aaron Rivero <Aaron@logictcg.com><br>
<b>Cc:</b> Logic TCG Support <support@logictcg.com>; qgis-user@lists.osgeo.org<br>
<b>Subject:</b> RE: T20240617.0042 - CRC | Jamie Buell | PC Keeps Crashing / Very Slow when using QGIS<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" align="left" width="100%" style="width:100.0%">
<tbody>
<tr>
<td style="background:#A6A6A6;padding:5.25pt 1.5pt 5.25pt 1.5pt"></td>
<td width="100%" style="width:100.0%;background:#EAEAEA;padding:5.25pt 3.75pt 5.25pt 11.25pt">
<div>
<p class="MsoNormal" style="mso-element:frame;mso-element-frame-hspace:2.25pt;mso-element-wrap:around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:column;mso-height-rule:exactly">
<span style="font-size:9.0pt;font-family:"Segoe UI",sans-serif;color:#212121;mso-ligatures:none;mso-fareast-language:EN-PH">You don't often get email from
<a href="mailto:richard.mcdonnell@opw.ie">richard.mcdonnell@opw.ie</a>. <a href="https://url.avanan.click/v2/___https:/aka.ms/LearnAboutSenderIdentification___.YXAzOmxvZ2ljdGNnOmE6bzo5YTIxYTJkYTU4ZjdiNDFlNDBhNmJiNzc1ZGU5MGY4ZDo2OjE4MDU6ODUyYjcwYTQ3Y2FmMjExZDlkM2RhN2FiMDMwOTMwNmM4NzJmOWI4M2U4ZTQ3MWEwNDE3OGJiMzdmMTZiZWM1YjpoOlQ" title="Protected by Avanan: https://aka.ms/LearnAboutSenderIdentification">
Learn why this is important</a><o:p></o:p></span></p>
</div>
</td>
<td width="75" style="width:56.25pt;background:#EAEAEA;padding:5.25pt 3.75pt 5.25pt 3.75pt;align:left">
</td>
</tr>
</tbody>
</table>
<div>
<p class="MsoNormal"><span lang="EN-IE" style="font-family:"Calibri",sans-serif;color:#1F497D">Hi Aron,<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-IE" style="font-family:"Calibri",sans-serif;color:#1F497D">Seems like you’re dealing with large dataset?<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-IE" style="font-family:"Calibri",sans-serif;color:#1F497D">A few things you can try.<o:p></o:p></span></p>
<ul style="margin-top:0cm" type="disc">
<li class="MsoListParagraph" style="color:#1F497D;margin-left:0cm;mso-list:l0 level1 lfo2">
<span lang="EN-IE" style="font-family:"Calibri",sans-serif">Make sure the datasets your running analysis on, or carrying out spatial joins on, all datasets have a Spatial Index. This can be done by going into the
<b>Layer Properties</b> and under <b>Source</b>, click <b>Create Spatial Index</b>.<o:p></o:p></span></li><li class="MsoListParagraph" style="color:#1F497D;margin-left:0cm;mso-list:l0 level1 lfo2">
<span lang="EN-IE" style="font-family:"Calibri",sans-serif">The other thing to consider is looking at how you can simplify your Tables, do you need all the attribution for analysis…etc<o:p></o:p></span></li><li class="MsoListParagraph" style="color:#1F497D;margin-left:0cm;mso-list:l0 level1 lfo2">
<span lang="EN-IE" style="font-family:"Calibri",sans-serif">One other thing to consider is moving the data from shapefile to a Spatial Database, something like PostGIS. I’m not sure, but you may even find moving to a GeoPackage may give you some performance
boost.<o:p></o:p></span></li></ul>
<p class="MsoNormal"><span lang="EN-IE" style="font-family:"Calibri",sans-serif;color:#1F497D">Just some thoughts.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-IE" style="font-family:"Calibri",sans-serif;color:#1F497D">Kind Regards,<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-IE" style="font-family:"Calibri",sans-serif;color:#1F497D"><br>
Richard<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-IE" style="font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="500" style="width:375.0pt">
<tbody>
<tr>
<td width="500" style="width:375.0pt;padding:0cm 0cm 4.5pt 0cm">
<p class="MsoNormal" style="line-height:11.25pt"><b><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#004D44;mso-ligatures:none;mso-fareast-language:EN-PH"><br>
——</span></b><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#004D44;mso-ligatures:none;mso-fareast-language:EN-PH"><br>
<b>Richard McDonnell MSc GIS, FME Certified Professional</b><br>
<i>Flood Risk Management - Data Management</i><br>
<br>
——<br>
<b>Oifig na nOibreacha Poiblí</b><br>
Office of Public Works<br>
<br>
</span><b><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#565148;mso-ligatures:none;mso-fareast-language:EN-PH">Sráid Jonathan Swift, Baile Átha Troim, Co na Mí, C15 NX36
</span></b><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#004D44;mso-ligatures:none;mso-fareast-language:EN-PH"><br>
</span><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#565148;mso-ligatures:none;mso-fareast-language:EN-PH">Jonathan Swift Street, Trim, Co Meath, C15 NX36</span><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#004D44;mso-ligatures:none;mso-fareast-language:EN-PH"><br>
</span><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#565148;mso-ligatures:none;mso-fareast-language:EN-PH">——</span><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#004D44;mso-ligatures:none;mso-fareast-language:EN-PH"><br>
</span><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#565148;mso-ligatures:none;mso-fareast-language:EN-PH">M +353 87 688 5964 T +353 46 942 2409</span><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#004D44;mso-ligatures:none;mso-fareast-language:EN-PH"><br>
<a href="https://url.avanan.click/v2/___https:/gov.ie/opw___.YXAzOmxvZ2ljdGNnOmE6bzo5YTIxYTJkYTU4ZjdiNDFlNDBhNmJiNzc1ZGU5MGY4ZDo2OjRkMDE6YjY5NjhjZTIwZTBhMGJlMWZkNmVmNDUwMzk2YmIyODA2MDA4YzM1Mjg5YmI3YTc1OTc3NmIxYWE3ODA4MDJhZTpoOlQ" title="Protected by Avanan: https://gov.ie/opw">https://gov.ie/opw</a><br>
<br>
——<br>
To send me files larger than 30MB, please use the link below <a href="https://url.avanan.click/v2/___https:/filetransfer.opw.ie/filedrop/richard.mcdonnell@opw.ie___.YXAzOmxvZ2ljdGNnOmE6bzo5YTIxYTJkYTU4ZjdiNDFlNDBhNmJiNzc1ZGU5MGY4ZDo2Ojc1MGU6NTQwNTAwNzUxYzUzOTZiOTAwOGJiNGZlY2YzN2ExOGY0ZDRmZGJmODlhMzE3OTMzMmUxMWJmNjk4Y2ZhMjRiNDp0OlQ">
https://url.avanan.click/v2/___https://filetransfer.opw.ie/filedrop/richard.mcdonnell@opw.ie___.YXAzOmxvZ2ljdGNnOmE6bzo5YTIxYTJkYTU4ZjdiNDFlNDBhNmJiNzc1ZGU5MGY4ZDo2Ojc1MGU6NTQwNTAwNzUxYzUzOTZiOTAwOGJiNGZlY2YzN2ExOGY0ZDRmZGJmODlhMzE3OTMzMmUxMWJmNjk4Y2ZhMjRiNDp0OlQ</a><br>
<br>
Email Disclaimer: <a href="https://url.avanan.click/v2/___https:/www.gov.ie/en/organisation-information/439daf-email-disclaimer/___.YXAzOmxvZ2ljdGNnOmE6bzo5YTIxYTJkYTU4ZjdiNDFlNDBhNmJiNzc1ZGU5MGY4ZDo2OjA1NTA6M2ZhOTA3NTk2ZjMzMGQ0NmM5ZmM0Yjk1Y2JlNGYxMTE2YjYyOGM3MGZlMjFlYzJhYTY4NzNiNjdlMmMxZTY3ZTp0OlQ">
https://url.avanan.click/v2/___https://www.gov.ie/en/organisation-information/439daf-email-disclaimer/___.YXAzOmxvZ2ljdGNnOmE6bzo5YTIxYTJkYTU4ZjdiNDFlNDBhNmJiNzc1ZGU5MGY4ZDo2OjA1NTA6M2ZhOTA3NTk2ZjMzMGQ0NmM5ZmM0Yjk1Y2JlNGYxMTE2YjYyOGM3MGZlMjFlYzJhYTY4NzNiNjdlMmMxZTY3ZTp0OlQ</a>
<o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
<div style="border:none;border-left:solid blue 1.5pt;padding:0cm 0cm 0cm 4.0pt">
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span lang="EN-US" style="font-family:"Calibri",sans-serif;mso-ligatures:none;mso-fareast-language:EN-IE">From:</span></b><span lang="EN-US" style="font-family:"Calibri",sans-serif;mso-ligatures:none;mso-fareast-language:EN-IE"> QGIS-User
<<a href="mailto:qgis-user-bounces@lists.osgeo.org">qgis-user-bounces@lists.osgeo.org</a>>
<b>On Behalf Of </b>Aaron Rivero via QGIS-User<br>
<b>Sent:</b> 18 June 2024 17:01<br>
<b>To:</b> <a href="mailto:qgis-user@lists.osgeo.org">qgis-user@lists.osgeo.org</a><br>
<b>Cc:</b> Logic TCG Support <<a href="mailto:support@logictcg.com">support@logictcg.com</a>><br>
<b>Subject:</b> [Qgis-user] T20240617.0042 - CRC | Jamie Buell | PC Keeps Crashing / Very Slow when using QGIS<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><span lang="EN-IE"><o:p> </o:p></span></p>
<p class="MsoNormal">Hi QGIS Team,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Happy Monday!<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">We need your help with this app issue. My user is trying to generate vector tiles of a polygon shapefile of census tracts for California. When she has successfully run this command before, it took a consecutive 36 hours with no other applications
running for the process to complete. Most of the times she has tried to run this, QGIS crashes, and sometimes her computer completely crashes.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Many other commands take a very long time. She tried to do a spatial join yesterday of about 400 points with the census tract shapefile, which took 2-3 hours.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">When I connected to the computer, there was an error message related to memory. She has 16GB of memory, and when she runs the command, it uses around 95 to 98 percent of the memory resources.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="mso-ligatures:none"><img border="0" width="484" height="226" style="width:5.0416in;height:2.3541in" id="Picture_x0020_1" src="cid:image001.jpg@01DAC161.154D31E0"></span><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Please let me know if you need more information on this issue.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Regards,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">-Aaron<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</div>
</div>
</body>
</html>