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

[Martin Chapman]

Oh sweet.  I never knew that option existed in OGR!  Thanks for the info
Even.

Marty

-----Original Message-----
From: Even Rouault [mailto:even.rouault at mines-paris.org]
Sent: Wednesday, April 04, 2012 1:12 PM
To: gdal-dev at lists.osgeo.org
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: 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