[Qgis-developer] save as spatialite very resource consuming

[kimaidou]

Hi Andrea,

Thanks for your answer. This is great news.

Cheers
Michael


2014-01-30 Andrea Peri <aperi2007 at gmail.com>

> 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
>> 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
>>>
>>
>>
>> _______________________________________________
>> 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/bb714717/attachment.html>