[Qgis-developer] save as spatialite very resource consuming
aperi2007 at gmail.com
Thu Jan 30 08:53:00 PST 2014
The bug of initspatialmetada was resolved in dev versione of qgis.
Il 30/gen/2014 17:24 "kimaidou" <kimaidou at gmail.com> ha scritto:
> Hi all
> Could you try to use this commands in QGIS python console ? I have seen
> that the parameter 1 in the function initspatialmetadata is very important
> to have a very fast DB creation. If you are on Windows, change the path
> "/tmp/test.db" by a more appropriate one.
> from pyspatialite import dbapi2 as db
> sql = "select initspatialmetadata(1)"
> c.execute(sql) ; print [row for row in c]
> 2014-01-30 Stefan Keller <sfkeller at gmail.com>
>> I have to confirm that the file size is huge and saving performance is
>> I'd like to emphasize that this is a show stopper for me for/against
>> Spatialite to become "the Shapefile of the future"!
>> I did not yet look into the QGIS driver code, but I assume (and hope)
>> that at least the saving performance can be enhanced.
>> 2014/1/24 Rafael Krucker <rkrucker at hsr.ch>:
>> > Hello all
>> > I've noticed recently (QGIS 2.0.1, Windows 7 64 bit), that, when I'm
>> > processing a shapefile as layer, even very small ones, the operation
>> > as spatialite' takes forever. With a small shapefile (1 KB), the
>> process of
>> > converting takes up to 3 minutes, the generated spatiallite is then
>> > around 4000 bigger (4.21 MB). These ratios are the same, no matter how
>> > the file is, the time taken enlarges linearly it seems.
>> > When the export is a shapefile again, the whole thing is a matter of
>> > seconds.
>> > Is this due to some kind of buffering issues or does this conversetion
>> > simply take that many resources?
>> > Kind regards and thanks in advance for any pointers
>> > Rafael
>> > _______________________________________________
>> > Qgis-developer mailing list
>> > Qgis-developer at lists.osgeo.org
>> > http://lists.osgeo.org/mailman/listinfo/qgis-developer
>> Qgis-developer mailing list
>> Qgis-developer at lists.osgeo.org
> Qgis-developer mailing list
> Qgis-developer at lists.osgeo.org
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Qgis-developer