Re: [sqlite] Deleting journal files

2005-03-30 Thread Gé Weijers
The idea behind the transaction file is the following: The database is stored in pages of a fixed size. The first time a page is modified after the start of a transaction the old contents of the page are saved in the transaction log together with its index. Once the transaction is committed the

[sqlite] Deleting journal files

2005-03-29 Thread Aaron Schneider
Hello all, We've been using SQLite for our database needs in our new program version, and unfortunately, we've run into some corruption issues. We believe that the corruption has been caused by deleting journal files. The program is a music manager and when managing a portable device, we copy