On 25 Nov 2014, at 1:34am, Joseph Fernandes <[email protected]> wrote:
> a. Does WAL during an insert/update in the log file do any internal > search/sort > and then insert/update to the log or > b. Just appends the WAL log with the incoming insert/update entry, thus > keeping the > writes sequential and during a checkpoint (manual or automatic) does the > merging with the actual tables, > which as you pointed out will have to search/sort causing alot of random > disk access? An INSERT in WAL mode does far more than just add something to the end of the journal file. Numerous operations including, for examples, allocating pages and updating the primary index. It will slow operations quite a bit. I'm with some other posters on this: when logging modifications don't use SQLite, just append to a text/octet file in a simple short format. Only when it comes time to do your maintenance read that data from the text files into SQLite. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
