> Two ? One for the page holding the table, another for the page holding the > primary key ?
If table has INTEGER PRIMARY KEY then it is the same page I believe. :) I.e. table storage is in fact an index on rowid (or its alias). Pavel On Wed, Apr 6, 2011 at 10:50 AM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 6 Apr 2011, at 3:15pm, Pavel Ivanov wrote: > >> For each transaction SQLite must >> write all changed pages into WAL-journal. It would be at least one >> page per transaction. > > Two ? One for the page holding the table, another for the page holding the > primary key ? > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users