Oh sweet. I never knew that option existed in OGR! Thanks for the info Even.
Marty -----Original Message----- From: Even Rouault [mailto:[email protected]] Sent: Wednesday, April 04, 2012 1:12 PM To: [email protected] Cc: Martin Chapman; 'Jukka Rahkonen' Subject: Re: [gdal-dev] Slow writing into Spatialite with -skipfailures 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
