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