[Qgis-user] Faster Intersects
Dennis Burgess
dmburgess at linktechs.net
Fri Sep 9 09:50:15 PDT 2022
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 <senhor.neto at gmail.com>
Sent: Friday, September 9, 2022 11:19 AM
To: Dennis Burgess <dmburgess at linktechs.net>
Cc: QGIS User <qgis-user at lists.osgeo.org>
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 <qgis-user at lists.osgeo.org<mailto:qgis-user at lists.osgeo.org>> 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
Qgis-user at lists.osgeo.org<mailto: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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20220909/a91549f3/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 4424 bytes
Desc: image001.png
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20220909/a91549f3/attachment.png>
More information about the Qgis-user
mailing list