Re: [Qgis-user] Optimize QGIS Command_Line

2024-02-11 Thread Frank Broniewski via QGIS-User
From: Frank Broniewski Sent: Wednesday, February 7, 2024 12:35:52 AM To: QGIS-User@lists.osgeo.org; Dennis Burgess Subject: AW: [Qgis-user] Optimize QGIS Command_Line Hi Dennis, concerning your first command, is your GeoPackage stored locally or on a network drive? Writing SQLite

Re: [Qgis-user] Optimize QGIS Command_Line

2024-02-10 Thread Dennis Burgess via QGIS-User
gig ram, NVME disks. From: Johannes Kröger (WhereGroup) Sent: Tuesday, February 6, 2024 2:01 AM To: Dennis Burgess ; QGIS-User@lists.osgeo.org Subject: Re: [Qgis-user] Optimize QGIS Command_Line Hey Dennis, can you share those command lines (maybe with sensitive information stripped)? Othe

Re: [Qgis-user] Optimize QGIS Command_Line

2024-02-06 Thread Frank Broniewski via QGIS-User
ks. From: Johannes Kröger (WhereGroup) Sent: Tuesday, February 6, 2024 2:01 AM To: Dennis Burgess ; QGIS-User@lists.osgeo.org Subject: Re: [Qgis-user] Optimize QGIS Command_Line Hey Dennis, can you share those command lines (maybe with sensitive information stripped)? Otherwise it is hard to

Re: [Qgis-user] Optimize QGIS Command_Line

2024-02-06 Thread Dennis Burgess via QGIS-User
er (WhereGroup) Sent: Tuesday, February 6, 2024 2:01 AM To: Dennis Burgess ; QGIS-User@lists.osgeo.org Subject: Re: [Qgis-user] Optimize QGIS Command_Line Hey Dennis, can you share those command lines (maybe with sensitive information stripped)? Otherwise it is hard to guess what the issue might be.

Re: [Qgis-user] Optimize QGIS Command_Line

2024-02-06 Thread WhereGroup
Hey Dennis, can you share those command lines (maybe with sensitive information stripped)? Otherwise it is hard to guess what the issue might be. What does your CPU, RAM and I/O utilisation look like during those long running processes? Same for the MSSQL database server host system. Cheers

[Qgis-user] Optimize QGIS Command_Line

2024-02-05 Thread Dennis Burgess via QGIS-User
I have two command lines, one reads from my MSSQL database and creates a GeoPackage on the local disk. This takes WAY too long, just to create it , it uses 5% or less CPU, and is SUPER slow. Looking for methods to speed this up. The data is around 1.2 to 1.4 gig of pop, but it should not take