I am using SQLite 3.24.0, as a single user persistent data store for storing simulation data.
The database can grow to many gigabytes as the software can ingest a lot of binary data which I store as multiple BLOBs. In the following example I am reading several 22GB of data into the DB. Times in seconds In WAL mode Read data & creating DB records 503.227 Commit of transaction,close database 334 In non-WAL mode Read data & creating DB records 244 Commit of transaction ,close database 4 WAL mode is 80-100x slower to commit to the database. I am probably abusing WAL mode, but I do not see anything in the documentation which says "don't use WAL mode in the following use case". Full disclosure, I am using ODB ( C++ ORM) that hides what is going on under the hood, but my experience is that in a simple use case like this ODB is not the problem. Andrew _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
