[Qgis-user] T20240617.0042 - CRC | Jamie Buell | PC Keeps Crashing /

[Drew French]

A geopackafge is a sqlite container so you got your database right there.

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.
Andrew French

On Tue, Jun 18, 2024, 11:31 AM <qgis-user-request at lists.osgeo.org> wrote:

> Send QGIS-User mailing list submissions to
>         qgis-user at lists.osgeo.org
>
> To subscribe or unsubscribe via the World Wide Web, visit
>         https://lists.osgeo.org/mailman/listinfo/qgis-user
> or, via email, send a message with subject or body 'help' to
>         qgis-user-request at lists.osgeo.org
>
> You can reach the person managing the list at
>         qgis-user-owner at lists.osgeo.org
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of QGIS-User digest..."
>
>
> Today's Topics:
>
>    1. Re: T20240617.0042 - CRC | Jamie Buell | PC Keeps Crashing /
>       Very Slow when using QGIS (Randal Hale)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Tue, 18 Jun 2024 12:30:38 -0400
> From: Randal Hale <rjhale at northrivergeographic.com>
> To: qgis-user at lists.osgeo.org
> Subject: Re: [Qgis-user] T20240617.0042 - CRC | Jamie Buell | PC Keeps
>         Crashing / Very Slow when using QGIS
> Message-ID:
>         <42c2f065-18fc-4e03-b705-14e48f39f27a at northrivergeographic.com>
> Content-Type: text/plain; charset="utf-8"; Format="flowed"
>
> Well - I think Richard beat me to the punch. I'd convert it to
> Geopackage and make sure it has a spatial index as a first shot.
>
> Randy
>
> On 6/18/24 12:01, Aaron Rivero via QGIS-User wrote:
> >
> > Hi QGIS Team,
> >
> > Happy Monday!
> >
> > 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.
> >
> > 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.
> >
> > 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.
> >
> > Please let me know if you need more information on this issue.
> >
> > Regards,
> >
> > -Aaron
> >
> >
> > _______________________________________________
> > QGIS-User mailing list
> > QGIS-User at lists.osgeo.org
> > List info:https://lists.osgeo.org/mailman/listinfo/qgis-user
> > Unsubscribe:https://lists.osgeo.org/mailman/listinfo/qgis-user
>
> --
> -----------------------------------
> North River Geographic Systems, Inc
> https://northrivergeographic.com
> rjhale at northrivergeographic.com
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <
> http://lists.osgeo.org/pipermail/qgis-user/attachments/20240618/02e710fb/attachment.htm
> >
> -------------- next part --------------
> A non-text attachment was scrubbed...
> Name: image001.png
> Type: image/png
> Size: 153382 bytes
> Desc: not available
> URL: <
> http://lists.osgeo.org/pipermail/qgis-user/attachments/20240618/02e710fb/attachment.png
> >
>
> ------------------------------
>
> Subject: Digest Footer
>
> _______________________________________________
> QGIS-User mailing list
> QGIS-User at lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
>
>
> ------------------------------
>
> End of QGIS-User Digest, Vol 220, Issue 27
> ******************************************
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20240618/cfcccb22/attachment.htm>