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.clktrk
_______________________________________________
Geoserver-devel mailing list
Geoserver-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-devel
