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: [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
