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@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.kroe...@wheregroup.com
www.wheregroup.com
Geschäftsführer:
Olaf Knopp, Peter Stamm
Amtsgericht Bonn, HRB 9885
-------------------------------
_______________________________________________
QGIS-User mailing list
QGIS-User@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user