Le mercredi 04 avril 2012 21:01:29, Martin Chapman a écrit : > Try to execute this query before you start inserting: > > "PRAGMA synchronous = 0;" > > It turns synchronous writes off for sqlite and give a big performance > increase. I don't know if that will work for spatialite but it might. > You need to read about the ramifications on the sqlite web site first > though so you understand the trade-offs. Also, it may have no effect when > using it via gdal. I can't answer that one.
Good suggestion. Actually this can be used with GDAL by setting the OGR_SQLITE_SYNCHRONOUS configuration option to OFF. See http://gdal.org/ogr/drv_sqlite.html > > Martin > > -----Original Message----- > From: [email protected] > [mailto:[email protected]] On Behalf Of Jukka Rahkonen > Sent: Wednesday, April 04, 2012 10:37 AM > To: [email protected] > Subject: [gdal-dev] Slow writing into Spatialite with -skipfailures > > Hi, > > I had to write a million polygon shapefile into Spatialite with > -skipfailures and I noticed that it was very many times slower that > without -skipfailures. Is there some logical reason for that or could it > be due to a bug or something? > Only thing that comes into my mind is that if the -gt parameter is taken > into account or not. > > -Jukka Rahkonen- > > _______________________________________________ > gdal-dev mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/gdal-dev > _______________________________________________ > gdal-dev mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/gdal-dev _______________________________________________ gdal-dev mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/gdal-dev
