https://issues.qgis.org/https://issues.qgis.org/favicon.ico2018-09-10T17:30:05ZQGIS Issue TrackingQGIS Application - Feature request #19814: QGIS3: "no spatial index" for package layers https://issues.qgis.org/issues/19814?journal_id=927082018-09-10T17:30:05ZTobias Wendorfftobias.wendorff@tu-dortmund.de
<ul></ul><p>time <ins>saver</ins>... hell</p> QGIS Application - Feature request #19814: QGIS3: "no spatial index" for package layers https://issues.qgis.org/issues/19814?journal_id=933532018-09-24T12:37:07ZJukka Rahkonenjukka.rahkonen@mmmtike.fi
<ul></ul><p>Tobias Wendorff wrote:</p>
<blockquote>
<p><strong>Please add a toggle to disable the creation of spatial indexes.</strong> Sometimes, it's needed to quickly export data into GPKG (end of working day or whatever). The creation of spatial indexes take a very long time. This would be a huge time safer.</p>
</blockquote>
<p>Please define "huge" and "very long time" with a pointer to test data.</p>
<p>I took some timings with ogr2ogr. This took 16 seconds with 1 million polygons:</p>
<p>ogr2ogr -f gpkg -lco spatial_index=no no_index.gpkg test.shp</p>
<p>With "-lco spatial_index=yes" the conversion took 32 seconds. It is two times more which is big difference but I would not call the 16 seconds that gets wasted as very long time.</p>
<p>If you experience times which are very different it is possible that QGIS is doing something else wrong.</p> QGIS Application - Feature request #19814: QGIS3: "no spatial index" for package layers https://issues.qgis.org/issues/19814?journal_id=933552018-09-24T12:39:54ZGiovanni Manghigiovanni.manghi@gmail.com
<ul><li><strong>Status</strong> changed from <i>Open</i> to <i>Feedback</i></li></ul> QGIS Application - Feature request #19814: QGIS3: "no spatial index" for package layers https://issues.qgis.org/issues/19814?journal_id=974382018-12-24T08:26:03ZAlexander Bruy
<ul><li><strong>Resolution</strong> set to <i>no timely feedback</i></li><li><strong>Status</strong> changed from <i>Feedback</i> to <i>Closed</i></li></ul><p>Closed for the lack of feedback. Please reopen if necessary.</p>