[Qgis-user] Faster Intersects

[Dennis Burgess]

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>