<div dir="auto">A geopackafge is a sqlite container so you got your database right there. <div dir="auto"><br></div><div dir="auto">This sounds like a problem I had with a Netcdf I got from NASA. I tried to load it and my RAM usage shit up to 90%, shutting down was the only way to solve. Never figured why that particular file did that. Sure, it was a 500mb file, but I can open a tif of that size without that type of memory use. </div><div dir="auto">Andrew French</div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Tue, Jun 18, 2024, 11:31 AM <<a href="mailto:qgis-user-request@lists.osgeo.org">qgis-user-request@lists.osgeo.org</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Send QGIS-User mailing list submissions to<br>
<a href="mailto:qgis-user@lists.osgeo.org" target="_blank" rel="noreferrer">qgis-user@lists.osgeo.org</a><br>
<br>
To subscribe or unsubscribe via the World Wide Web, visit<br>
<a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noreferrer noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
or, via email, send a message with subject or body 'help' to<br>
<a href="mailto:qgis-user-request@lists.osgeo.org" target="_blank" rel="noreferrer">qgis-user-request@lists.osgeo.org</a><br>
<br>
You can reach the person managing the list at<br>
<a href="mailto:qgis-user-owner@lists.osgeo.org" target="_blank" rel="noreferrer">qgis-user-owner@lists.osgeo.org</a><br>
<br>
When replying, please edit your Subject line so it is more specific<br>
than "Re: Contents of QGIS-User digest..."<br>
<br>
<br>
Today's Topics:<br>
<br>
1. Re: T20240617.0042 - CRC | Jamie Buell | PC Keeps Crashing /<br>
Very Slow when using QGIS (Randal Hale)<br>
<br>
<br>
----------------------------------------------------------------------<br>
<br>
Message: 1<br>
Date: Tue, 18 Jun 2024 12:30:38 -0400<br>
From: Randal Hale <<a href="mailto:rjhale@northrivergeographic.com" target="_blank" rel="noreferrer">rjhale@northrivergeographic.com</a>><br>
To: <a href="mailto:qgis-user@lists.osgeo.org" target="_blank" rel="noreferrer">qgis-user@lists.osgeo.org</a><br>
Subject: Re: [Qgis-user] T20240617.0042 - CRC | Jamie Buell | PC Keeps<br>
Crashing / Very Slow when using QGIS<br>
Message-ID:<br>
<<a href="mailto:42c2f065-18fc-4e03-b705-14e48f39f27a@northrivergeographic.com" target="_blank" rel="noreferrer">42c2f065-18fc-4e03-b705-14e48f39f27a@northrivergeographic.com</a>><br>
Content-Type: text/plain; charset="utf-8"; Format="flowed"<br>
<br>
Well - I think Richard beat me to the punch. I'd convert it to <br>
Geopackage and make sure it has a spatial index as a first shot.<br>
<br>
Randy<br>
<br>
On 6/18/24 12:01, Aaron Rivero via QGIS-User wrote:<br>
><br>
> Hi QGIS Team,<br>
><br>
> Happy Monday!<br>
><br>
> We need your help with this app issue. My user is trying to generate <br>
> vector tiles of a polygon shapefile of census tracts for California. <br>
> When she has successfully run this command before, it took a <br>
> consecutive 36 hours with no other applications running for the <br>
> process to complete. Most of the times she has tried to run this, QGIS <br>
> crashes, and sometimes her computer completely crashes.<br>
><br>
> Many other commands take a very long time. She tried to do a spatial <br>
> join yesterday of about 400 points with the census tract shapefile, <br>
> which took 2-3 hours.<br>
><br>
> When I connected to the computer, there was an error message related <br>
> to memory. She has 16GB of memory, and when she runs the command, it <br>
> uses around 95 to 98 percent of the memory resources.<br>
><br>
> Please let me know if you need more information on this issue.<br>
><br>
> Regards,<br>
><br>
> -Aaron<br>
><br>
><br>
> _______________________________________________<br>
> QGIS-User mailing list<br>
> <a href="mailto:QGIS-User@lists.osgeo.org" target="_blank" rel="noreferrer">QGIS-User@lists.osgeo.org</a><br>
> List info:<a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noreferrer noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
> Unsubscribe:<a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noreferrer noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
<br>
-- <br>
-----------------------------------<br>
North River Geographic Systems, Inc<br>
<a href="https://northrivergeographic.com" rel="noreferrer noreferrer" target="_blank">https://northrivergeographic.com</a><br>
<a href="mailto:rjhale@northrivergeographic.com" target="_blank" rel="noreferrer">rjhale@northrivergeographic.com</a><br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <<a href="http://lists.osgeo.org/pipermail/qgis-user/attachments/20240618/02e710fb/attachment.htm" rel="noreferrer noreferrer" target="_blank">http://lists.osgeo.org/pipermail/qgis-user/attachments/20240618/02e710fb/attachment.htm</a>><br>
-------------- next part --------------<br>
A non-text attachment was scrubbed...<br>
Name: image001.png<br>
Type: image/png<br>
Size: 153382 bytes<br>
Desc: not available<br>
URL: <<a href="http://lists.osgeo.org/pipermail/qgis-user/attachments/20240618/02e710fb/attachment.png" rel="noreferrer noreferrer" target="_blank">http://lists.osgeo.org/pipermail/qgis-user/attachments/20240618/02e710fb/attachment.png</a>><br>
<br>
------------------------------<br>
<br>
Subject: Digest Footer<br>
<br>
_______________________________________________<br>
QGIS-User mailing list<br>
<a href="mailto:QGIS-User@lists.osgeo.org" target="_blank" rel="noreferrer">QGIS-User@lists.osgeo.org</a><br>
List info: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noreferrer noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
Unsubscribe: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noreferrer noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
<br>
<br>
------------------------------<br>
<br>
End of QGIS-User Digest, Vol 220, Issue 27<br>
******************************************<br>
</blockquote></div>