Is there a postGIS or other community, I need an automated method to move data from MSSQL to POSTGIS for processing? And will postgis run faster than MSSQL? Will it use all cores?
[LTI-Full_175px] Dennis Burgess Author of "Learn RouterOS- Second Edition” Link Technologies, Inc -- Mikrotik & WISP Support Services Office: 314-735-0270 Website: http://www.linktechs.net<http://www.linktechs.net/> Create Wireless Coverage’s with www.towercoverage.com Need MikroTik Cloud Management: https://cloud.linktechs.net From: Alexandre Neto <[email protected]> Sent: Friday, September 9, 2022 11:19 AM To: Dennis Burgess <[email protected]> Cc: QGIS User <[email protected]> Subject: Re: [Qgis-user] Faster Intersects I don't know what is your data format, but make sure you have spatial index in it. For things with millions of points I would move the data into PostGIS for definitely faster processing. Alexandre Neto User Support A sexta, 9/09/2022, 15:50, Dennis Burgess via Qgis-user <[email protected]<mailto:[email protected]>> escreveu: How can I speed up Intersects? Right now I have a single geometry file, but then have about 2 million points that I need to understand what intersects that geometry. Right now its taking 3 days? QGIS-bin.exe is only using 11% CPU.. ☹ Dennis _______________________________________________ Qgis-user mailing list [email protected]<mailto:[email protected]> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
_______________________________________________ Qgis-user mailing list [email protected] List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
