On Fri, Jan 1, 2010 at 8:11 PM, Bert Nelsen <bert.nel...@googlemail.com>wrote:
> So SQLite looks at both the database on the disk and in memory? > Wouldn't that be difficult??? > I don't think that only the memory can be used. Imagine you can have a very big transaction, 1,000,000 inserts. As long as I understand the architecture, all affected sectors are saved in .db3-journal file so the db3 file itself always reflects the current state of the database. For example you have a table with 100 records and you're inserting 1,000,000 records, so at the final stage, right before Commit, your db3 file contains all these 1,000,100 records and the indexes changed accordingly, while the corresponding db-journal consists of the data needed to restore the db file to the state it was before the transaction began _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users