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: gdal-dev-boun...@lists.osgeo.org > [mailto:gdal-dev-boun...@lists.osgeo.org] On Behalf Of Jukka Rahkonen > Sent: Wednesday, April 04, 2012 10:37 AM > To: gdal-dev@lists.osgeo.org > 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 > gdal-dev@lists.osgeo.org > http://lists.osgeo.org/mailman/listinfo/gdal-dev > _______________________________________________ > gdal-dev mailing list > gdal-dev@lists.osgeo.org > http://lists.osgeo.org/mailman/listinfo/gdal-dev _______________________________________________ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev
