[Qgis-developer] save as spatialite very resource consuming

[kimaidou]

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
conn=db.connect('/tmp/test.db')
c=conn.cursor()
sql = "select initspatialmetadata(1)"
c.execute(sql) ; print [row for row in c]

Michael


2014-01-30 Stefan Keller <sfkeller at gmail.com>

> 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
> _______________________________________________
> Qgis-developer mailing list
> Qgis-developer at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-developer
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20140130/ed71a3b0/attachment.html>