<html><head><meta http-equiv="content-type" content="text/html; charset=utf-8"></head><body dir="auto">Hi,<div>Geopackage has a build in index. So you don’t need to build it.<br><br><div dir="ltr">Nicolas Cadieux<div><a href="https://gitlab.com/njacadieux">https://gitlab.com/njacadieux</a></div></div><div dir="ltr"><br><blockquote type="cite">Le 9 sept. 2022 à 13:50, Raymond Nijssen via Qgis-user <qgis-user@lists.osgeo.org> a écrit :<br><br></blockquote></div><blockquote type="cite"><div dir="ltr"><span>Great! \o/</span><br><span></span><br><span></span><br><span>On 09-09-2022 19:25, Dennis Burgess wrote:</span><br><blockquote type="cite"><span>That did it!!! I was unware that GeoPackage’s are SUPER fast and that I could SAVE a CSV as a GeoPackage file. . There is no metho to create indexes though once I do this, but now it runs in about 2 min! lol</span><br></blockquote><blockquote type="cite"><span>*LTI-Full_175px*</span><br></blockquote><blockquote type="cite"><span>*Dennis Burgess*</span><br></blockquote><blockquote type="cite"><span>*</span><br></blockquote><blockquote type="cite"><span>*Author of "Learn RouterOS- Second Edition”</span><br></blockquote><blockquote type="cite"><span>*Link Technologies, Inc*-- Mikrotik & WISP Support Services</span><br></blockquote><blockquote type="cite"><span>*Office*: 314-735-0270 Website: http://www.linktechs.net <http://www.linktechs.net/></span><br></blockquote><blockquote type="cite"><span>Create Wireless Coverage’s with www.towercoverage.com <www.towercoverage.com></span><br></blockquote><blockquote type="cite"><span>Need MikroTik Cloud Management: https://cloud.linktechs.net <https://cloud.linktechs.net></span><br></blockquote><blockquote type="cite"><span>*From:* Alexandre Neto <senhor.neto@gmail.com></span><br></blockquote><blockquote type="cite"><span>*Sent:* Friday, September 9, 2022 12:20 PM</span><br></blockquote><blockquote type="cite"><span>*To:* Dennis Burgess <dmburgess@linktechs.net></span><br></blockquote><blockquote type="cite"><span>*Cc:* Raymond Nijssen <r.nijssen@terglobo.nl>; QGIS User <qgis-user@lists.osgeo.org></span><br></blockquote><blockquote type="cite"><span>*Subject:* Re: [Qgis-user] Faster Intersects</span><br></blockquote><blockquote type="cite"><span>Following raymond advice,</span><br></blockquote><blockquote type="cite"><span>Move the CSV to a shapefile or geopackage and run the create spatial index on it.</span><br></blockquote><blockquote type="cite"><span>If you have very complex polygons, use suvdivide to create smaller ones save it in shapefile or geopackage and run create spatial index on it.</span><br></blockquote><blockquote type="cite"><span>https://docs.qgis.org/3.22/en/docs/user_manual/processing_algs/qgis/vectorgeometry.html#subdivide <https://docs.qgis.org/3.22/en/docs/user_manual/processing_algs/qgis/vectorgeometry.html#subdivide></span><br></blockquote><blockquote type="cite"><span>I would try with a smaller subset of points to test the improvement speed before trying to run on the full dataset again.</span><br></blockquote><blockquote type="cite"><span>Answering your question, yes I am pretty sure postgis is much faster than mssql, and yes I think most recent versions of PostgreSQL PostGIS make use of more than one core.</span><br></blockquote><blockquote type="cite"><span>Good luck</span><br></blockquote><blockquote type="cite"><span>A sexta, 9/09/2022, 17:59, Dennis Burgess via Qgis-user <qgis-user@lists.osgeo.org <mailto:qgis-user@lists.osgeo.org>> escreveu:</span><br></blockquote><blockquote type="cite"><span> In the format, are you talking about the shape or the CSV with</span><br></blockquote><blockquote type="cite"><span> 2million lines?</span><br></blockquote><blockquote type="cite"><span> Dennis Burgess</span><br></blockquote><blockquote type="cite"><span> Author of "Learn RouterOS- Second Edition”</span><br></blockquote><blockquote type="cite"><span> Link Technologies, Inc -- Mikrotik & WISP Support Services</span><br></blockquote><blockquote type="cite"><span> Office: 314-735-0270 Website: http://www.linktechs.net</span><br></blockquote><blockquote type="cite"><span> <http://www.linktechs.net></span><br></blockquote><blockquote type="cite"><span> Create Wireless Coverage’s with www.towercoverage.com</span><br></blockquote><blockquote type="cite"><span> <http://www.towercoverage.com></span><br></blockquote><blockquote type="cite"><span> Need MikroTik Cloud Management: https://cloud.linktechs.net</span><br></blockquote><blockquote type="cite"><span> <https://cloud.linktechs.net></span><br></blockquote><blockquote type="cite"><span> -----Original Message-----</span><br></blockquote><blockquote type="cite"><span> From: Qgis-user <qgis-user-bounces@lists.osgeo.org</span><br></blockquote><blockquote type="cite"><span> <mailto:qgis-user-bounces@lists.osgeo.org>> On Behalf Of Raymond</span><br></blockquote><blockquote type="cite"><span> Nijssen via Qgis-user</span><br></blockquote><blockquote type="cite"><span> Sent: Friday, September 9, 2022 11:11 AM</span><br></blockquote><blockquote type="cite"><span> To: qgis-user@lists.osgeo.org <mailto:qgis-user@lists.osgeo.org></span><br></blockquote><blockquote type="cite"><span> Subject: Re: [Qgis-user] Faster Intersects</span><br></blockquote><blockquote type="cite"><span> Some things to check:</span><br></blockquote><blockquote type="cite"><span> * Is your data local?</span><br></blockquote><blockquote type="cite"><span> * Is it in a fast file format? (for example .gpkg or .shp and not</span><br></blockquote><blockquote type="cite"><span> .csv or .geojson)</span><br></blockquote><blockquote type="cite"><span> * Does the data have a spatial index?</span><br></blockquote><blockquote type="cite"><span> * Is the geometry very complicated, like a huge multi polygon with</span><br></blockquote><blockquote type="cite"><span> thousands of vertices and islands? In that case, split it up in</span><br></blockquote><blockquote type="cite"><span> several polygons.</span><br></blockquote><blockquote type="cite"><span> Hope this helps. Anyway, it should not need to take this long.</span><br></blockquote><blockquote type="cite"><span> Raymond</span><br></blockquote><blockquote type="cite"><span> On 09-09-2022 16:28, Dennis Burgess via Qgis-user wrote:</span><br></blockquote><blockquote type="cite"><span> > How can I speed up Intersects? Right now I have a single geometry</span><br></blockquote><blockquote type="cite"><span> > file, but then have about 2 million points that I need to understand</span><br></blockquote><blockquote type="cite"><span> > what intersects that geometry. Right now its taking 3 days?</span><br></blockquote><blockquote type="cite"><span> > QGIS-bin.exe is only using 11% CPU.. ☹</span><br></blockquote><blockquote type="cite"><span> ></span><br></blockquote><blockquote type="cite"><span> > Dennis</span><br></blockquote><blockquote type="cite"><span> ></span><br></blockquote><blockquote type="cite"><span> ></span><br></blockquote><blockquote type="cite"><span> > _______________________________________________</span><br></blockquote><blockquote type="cite"><span> > Qgis-user mailing list</span><br></blockquote><blockquote type="cite"><span> > Qgis-user@lists.osgeo.org <mailto:Qgis-user@lists.osgeo.org></span><br></blockquote><blockquote type="cite"><span> > List info: https://lists.osgeo.org/mailman/listinfo/qgis-user</span><br></blockquote><blockquote type="cite"><span> <https://lists.osgeo.org/mailman/listinfo/qgis-user></span><br></blockquote><blockquote type="cite"><span> > Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user</span><br></blockquote><blockquote type="cite"><span> <https://lists.osgeo.org/mailman/listinfo/qgis-user></span><br></blockquote><blockquote type="cite"><span> _______________________________________________</span><br></blockquote><blockquote type="cite"><span> Qgis-user mailing list</span><br></blockquote><blockquote type="cite"><span> Qgis-user@lists.osgeo.org <mailto:Qgis-user@lists.osgeo.org></span><br></blockquote><blockquote type="cite"><span> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user</span><br></blockquote><blockquote type="cite"><span> <https://lists.osgeo.org/mailman/listinfo/qgis-user></span><br></blockquote><blockquote type="cite"><span> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user</span><br></blockquote><blockquote type="cite"><span> <https://lists.osgeo.org/mailman/listinfo/qgis-user></span><br></blockquote><blockquote type="cite"><span> _______________________________________________</span><br></blockquote><blockquote type="cite"><span> Qgis-user mailing list</span><br></blockquote><blockquote type="cite"><span> Qgis-user@lists.osgeo.org <mailto:Qgis-user@lists.osgeo.org></span><br></blockquote><blockquote type="cite"><span> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user</span><br></blockquote><blockquote type="cite"><span> <https://lists.osgeo.org/mailman/listinfo/qgis-user></span><br></blockquote><blockquote type="cite"><span> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user</span><br></blockquote><blockquote type="cite"><span> <https://lists.osgeo.org/mailman/listinfo/qgis-user></span><br></blockquote><span>_______________________________________________</span><br><span>Qgis-user mailing list</span><br><span>Qgis-user@lists.osgeo.org</span><br><span>List info: https://lists.osgeo.org/mailman/listinfo/qgis-user</span><br><span>Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user</span><br></div></blockquote></div></body></html>