Can someone out there advise me as to why SQlite needs to perform so many writes to disk when executing an insert. The insert consists of 6 columns. There is a total of 5 indexes on the table. The average size of one of these records is around 800 bytes. We have an SQlite page size of 1024 bytes. But it seems that 10 pages are being written to.
This is one example of many. In another instance where we need to modify only 1 column and 1 record we see 2 page writes. Can anyone please advise as to why SQlite needs to update so many pages? I ask this as we are using a Flash filing system and we wish to improve the performance of writing records with SQlite. It would be helpful to know why SQlite needs to update so much of the database file on each update. Thanks in advance Mark
