[Qgis-user] Optimize QGIS Command_Line

[Johannes Kröger (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, Hannes

On 05.02.24 14:46, Dennis Burgess via QGIS-User wrote:
>
> 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 50 min to create.
>
> Also I am doing a dissolve on this data, once its on the disk, this 
> also takes quite a while, even though when I do it from QGIS it takes 
> like 10 min vs an hour or more on the computer with the command line.
>
> I’m sure I am doing something wrong on both of these. Just trying to 
> understand what it would be.
>
> Thanks for any assistance !
>
>
> Dennis
>
>
> _______________________________________________
> 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

-- 
Johannes Kröger / GIS-Entwickler/-Berater

---------------------------------------------
Aufwind durch Wissen!
Web-Seminare und Online-Schulungen
bei derwww.foss-academy.com
---------------------------------------------

WhereGroup GmbH
c/o KK03 GmbH
Lange Reihe 29
20099 Hamburg
Germany

Tel: +49 (0)228 / 90 90 38 - 36
Fax: +49 (0)228 / 90 90 38 - 11

johannes.kroeger at wheregroup.com
www.wheregroup.com
Geschäftsführer:
Olaf Knopp, Peter Stamm
Amtsgericht Bonn, HRB 9885
-------------------------------
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20240206/30ab7403/attachment.htm>