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

[Martin Chapman]

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.

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