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 :

  1. add the shapefile to a new project
  2. right click and Save as
  3. choose SQLite and save

Change History (2)

comment:1 by jrm, 14 years ago

There is the link to download the *.shp http://www.megaupload.com/?d=6LIGZ1XW

comment:2 by aghisla, 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.

Note: See TracTickets for help on using tickets.