[Qgis-developer] save as spatialite very resource consuming

[Stefan Keller]

Hi,

I have to confirm that the file size is huge and saving performance is slow.
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.

-Stefan

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 'save
> as spatialite' takes forever. With a small shapefile (1 KB), the process of
> converting takes up to 3 minutes, the generated spatiallite is then always
> around 4000 bigger (4.21 MB). These ratios are the same, no matter how big
> 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