[gdal-dev] Slow writing into Spatialite with -skipfailures

[Even Rouault]

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