Hi Andrea, Thanks for your answer. This is great news.
Cheers Michael 2014-01-30 Andrea Peri <[email protected]> > The bug of initspatialmetada was resolved in dev versione of qgis. > Il 30/gen/2014 17:24 "kimaidou" <[email protected]> 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 >> 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 <[email protected]> >> >>> 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 <[email protected]>: >>> > 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 >>> > [email protected] >>> > http://lists.osgeo.org/mailman/listinfo/qgis-developer >>> _______________________________________________ >>> Qgis-developer mailing list >>> [email protected] >>> http://lists.osgeo.org/mailman/listinfo/qgis-developer >>> >> >> >> _______________________________________________ >> Qgis-developer mailing list >> [email protected] >> http://lists.osgeo.org/mailman/listinfo/qgis-developer >> >
_______________________________________________ Qgis-developer mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/qgis-developer
