Re: [OSM-talk] DB Performance (was: JOSM plugin to import GeoJSON?_

2016-03-23 Thread Jukka Rahkonen
Hi, Stefan did not tell enough details for repeating the test exactly so my test set-up is probably a bit different. Program: GDAL 2.1.0dev, released 2015/99/99 on Windows, compiled with sqlite-3.10.2 and libspatialite-4.3.0a Test data: 100 points (2D) without attributes in shp format

[OSM-talk] DB Performance (was: JOSM plugin to import GeoJSON?_

2016-03-22 Thread Mike Thompson
This from the ogr2ogr documentation[1] may be relevant: "When writing into transactional DBMS (SQLite/PostgreSQL,MySQL, etc...), it might be beneficial to increase the number of INSERT statements executed between BEGIN TRANSACTION and COMMIT TRANSACTION statements. This number is specified with