Hi Jukka, I didn’t do any concrete timings this time, but I use these settings for a mobile project since years where I once did concrete timings (differential database updates on Android and iOS). It of course varies with the particular database, indices etc.
See also some performance measurements of different journal and synchronization modes here: http://stackoverflow.com/questions/1711631/improve-insert-per-second-perfor mance-of-sqlite Cheers Ben Am 11.12.14 07:04 schrieb "Rahkonen Jukka (Tike)" unter <jukka.rahko...@mmmtike.fi>: >Hi Benjamin, > >Your estimate about 100x - 1000x speedup makes me suspicious but I will >be happily surprised if it happens to be true. > >I would like to get some sample data and exact timings from your test for >repeating them. I mean from what you wrote " I¹ve played with Geopackage >in GDAL and creating a geopackage db via ogr2ogr was slow as well." Did >you compare the speed with creating a SpatiaLite db with ogr2ogr instead? > >-Jukka Rahkonen- > > > >________________________________________ >Stadin, Benjamin wrote: > >Hi, > >I didn¹t try GeoPackage plugin in GeoServer, I¹ve played with Geopackage >in GDAL and creating a geopackage db via ogr2ogr was slow as well. > >In my opinion it would be save for both GDAL as well as the GeoPackage >plugin to change the SQLite journaling mode to WAL and turn file >synchronization off (at least when creating databases). C Example: > >sqlite3_exec(db, "PRAGMA synchronous = OFF", NULL, NULL, NULL); > sqlite3_exec(db, "PRAGMA journal_mode = WAL", NULL, NULL, NULL); > >This must be done right after opening the database. The the insert / >delete performance difference is enorm (several orders of magnitude >compared to non-transactional inserts and also twice or three times faster >for transactions). > >A speedup between 100x - 1000x is not unlikely. This comes of course at >the slightly increased cost of db corruption (see also [1,2]). But even >then, it¹s debatable whether for the db utilization of both GeoServer and >GDAL this can be configuration enabled globally for all operations: rare >updates, still journaling enabled though with backup point from last disk >write time compared to constant disk sync journaling for each op. > >Cheers >Ben > >[1] https://www.sqlite.org/wal.html >[2] http://www.sqlite.org/pragma.html#pragma_journal_mode > > > > >Am 10.12.14 23:41 schrieb "Even Rouault" unter ><even.roua...@spatialys.com>: > >> * not really an issue, but generated that output file is extremely >>slow, >>like 30 seconds, and lot of noise done by harddisk ;-) > > >-------------------------------------------------------------------------- >---- >Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server >from Actuate! Instantly Supercharge Your Business Reports and Dashboards >with Interactivity, Sharing, Native Excel Exports, App Integration & more >Get technology previously reserved for billion-dollar corporations, FREE >http://pubads.g.doubleclick.net/gampad/clk?id=164703151&iu=/4140/ostg.clkt >rk >_______________________________________________ >Geoserver-devel mailing list >Geoserver-devel@lists.sourceforge.net >https://lists.sourceforge.net/lists/listinfo/geoserver-devel ------------------------------------------------------------------------------ Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server from Actuate! Instantly Supercharge Your Business Reports and Dashboards with Interactivity, Sharing, Native Excel Exports, App Integration & more Get technology previously reserved for billion-dollar corporations, FREE http://pubads.g.doubleclick.net/gampad/clk?id=164703151&iu=/4140/ostg.clktrk _______________________________________________ Geoserver-devel mailing list Geoserver-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-devel
