[QGIS-trac] [Quantum GIS] #3002: Slow convertion to spatialite using "Save as"

[Quantum GIS]

#3002: Slow convertion to spatialite using "Save as"
-----------------------------------+----------------------------------------
   Reporter:  jrm                  |              Owner:  nobody       
       Type:  bug                  |             Status:  new          
   Priority:  minor: annoyance     |          Milestone:  Version 1.6.0
  Component:  Data Provider        |            Version:  Trunk        
   Keywords:  slow sqlite convert  |   Platform_version:               
   Platform:  Mandriva             |           Must_fix:  No           
Status_info:  0                    |  
-----------------------------------+----------------------------------------
 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 :
 1. add the shapefile to a new project
 2. right click and Save as
 3. choose SQLite and save

-- 
Ticket URL: <https://trac.osgeo.org/qgis/ticket/3002>
Quantum GIS <http://qgis.org>
Quantum GIS is an Open Source GIS viewer/editor supporting OGR, PostGIS, and GRASS formats