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

[Jukka Rahkonen]

Jukka Rahkonen <jukka.rahkonen <at> mmmtike.fi> writes:


> The error is this one:
> ERROR 1: sqlite3_step() failed:
>   parcel.GEOMETRY violates Geometry constraint [geom-type or SRID 
not allowed] (
> 19)
> 
> Ogr2ogr managed to insert only 273886 polygons in 13 hours into spatialite
 db so
> I canceled the job instead of letting it run the remaining 40 hours.  
I will try
> the effect of OGR_SQLITE_SYNCHRONOUS=OFF.
> 
> -Jukka Rahkonen-

It took about two hours to insert 1.2 million polygons with -skipfailures and
OGR_SQLITE_SYNCHRONOUS=OFF. Increase from 21000 per hour into one million per
hour so it was fifty times faster with SYNCHRONOUS=OFF.

-Jukka Rahkonen-