Feature request #19814
QGIS3: "no spatial index" for package layers
| Status: | Closed | ||
|---|---|---|---|
| Priority: | Normal | ||
| Assignee: | - | ||
| Category: | Processing/Core | ||
| Pull Request or Patch supplied: | No | Resolution: | no timely feedback |
| Easy fix?: | No | Copied to github as #: | 27638 |
Description
Please add a toggle to disable the creation of spatial indexes. 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.
History
#1
Updated by Tobias Wendorff over 5 years ago
time saver... hell
#2
Updated by Jukka Rahkonen over 5 years ago
Tobias Wendorff wrote:
Please add a toggle to disable the creation of spatial indexes. 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.
Please define "huge" and "very long time" with a pointer to test data.
I took some timings with ogr2ogr. This took 16 seconds with 1 million polygons:
ogr2ogr -f gpkg -lco spatial_index=no no_index.gpkg test.shp
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.
If you experience times which are very different it is possible that QGIS is doing something else wrong.
#3
Updated by Giovanni Manghi over 5 years ago
- Status changed from Open to Feedback
#4
Updated by Alexander Bruy over 5 years ago
- Resolution set to no timely feedback
- Status changed from Feedback to Closed
Closed for the lack of feedback. Please reopen if necessary.