Opened 14 years ago
Last modified 13 years ago
#3002 new bug
Slow convertion to spatialite using "Save as"
Reported by: | jrm | Owned by: | nobody |
---|---|---|---|
Priority: | minor: annoyance | Milestone: | Version 1.7.0 |
Component: | Data Provider | Version: | Trunk |
Keywords: | slow sqlite convert | Cc: | |
Must Fix for Release: | No | Platform: | Mandriva |
Platform Version: | Awaiting user input: | no |
Description
Saving a shapefile to SQLite using the right click menu "Save as" is anormally slow, the qgis' process is constantly switching between jbd2_log_wait_commit and blkdev_issue_flush with less than 1% of the cpu. The convertion takes nearly one hour to complete.
Converting the same file with ogr2ogr is taking less than 30sec
ogr2ogr -f "SQLite" ~/rgc2009.sqlite ~/rgc2009.shp -a_srs EPSG:2154 -dsco SPATIALITE=yes
I've joined a test file, steps to reproduce :
- add the shapefile to a new project
- right click and Save as
- choose SQLite and save
Change History (2)
comment:1 by , 14 years ago
comment:2 by , 13 years ago
Tested with QGIS r15378, on a dual core running Fedora.
It takes 50 minutes to convert, but also more than one minute to display the shapefile, and the process takes on average less than 2%CPU and around 5% memory.
There is the link to download the *.shp http://www.megaupload.com/?d=6LIGZ1XW