Dear all, I'm experiencing than when I create a new empty spatialite from qgis it takes long time to do it. Here belo is the code I tried:
--------------- # -*- coding: utf-8 -*- from qgis.core import * import qgis.utils from pyspatialite import dbapi2 as db import timeit start = timeit.default_timer() dbase='/home/pierluigi/Scrivania/db.sqlite' conn = db.connect(dbase) cur = conn.cursor() sql = 'SELECT InitSpatialMetadata()' cur.execute(sql) conn.commit() stop = timeit.default_timer() print stop - start ----------- If i run this code my pc start swapping so much and to prepare the empty db (the total variable) it takes 722.3559 sec or better ABOUT 12 MINUTES!!! Of course the same is if I just save a layer into spatialite format. Why is this happens? Is there a work around for my code to speed up che db creation? I'm running qgis on ubuntu 14.04, qgis 2.8 LTS from launchpad unstable repo. Thanks Pierluigi -- ________________________________________________________________________ Ing. Pierluigi De Rosa (PhD) Studio Associato GFOSSERVICES Presso CAMPUS Via F.lli Cairoli 25 - 06127 Perugia (PG) fax: 075 7823038 cel: 3497558268 web: www.gfosservices.it skype: pierluigi.derosa _______________________________________________ Qgis-developer mailing list Qgis-developer@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-developer