Re: [sqlite] sqlite 4 bytes write

2008-08-19 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Julian Qian wrote: > I would like us to understand the write patterns of Sqlite. It looks like the 4 bytes is some sort of header for each database page. Your trace seems to be of the Android emulator rather than your application (there are no syncs

[sqlite] sqlite 4 bytes write

2008-08-19 Thread Julian Qian
I would like us to understand the write patterns of Sqlite. . That write pattern happens first to the journal then to the database. I found a lot of 4 byte writes. What are these 4 byte writes and can the be avoided? I would also like data on the write patterns for a 1k,2k,128k, and 256k writes to