Le mercredi 04 avril 2012 19:16:34, Rahkonen Jukka a écrit : > Even Rouault wrote: > >Selon Jukka Rahkonen <jukka.rahko...@mmmtike.fi>: > >> 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. > > > > This is expected. When you use -skipfailures, the -gt parameter is > > ignored and virtually set to 1 so that transactions only take into > > account one single feature at a time. > > Well, doing 1.1 million transactions for Spatialite db is too slow. Any > suggestions about how to clean the shapefile fast and effectively > beforehand? The shapefile is created by ogr2ogr, from Oracle table into > shapefile. I have used -nlt multipolygon in both runs (Oracle -> > shapefile, shape ->Spatialite).
What is the error reported when inserting features into the Spatialite DB that makes the use of -skipfailures necessary ? > > -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
