Feature request #19814

QGIS3: "no spatial index" for package layers

Added by Tobias Wendorff about 2 years ago. Updated almost 2 years ago.

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 about 2 years ago

time saver... hell

#2 Updated by Jukka Rahkonen about 2 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 about 2 years ago

  • Status changed from Open to Feedback

#4 Updated by Alexander Bruy almost 2 years ago

  • Resolution set to no timely feedback
  • Status changed from Feedback to Closed

Closed for the lack of feedback. Please reopen if necessary.

Also available in: Atom PDF