On Oct 1, 2008, at 10:41 AM, Calamani, Olga wrote: > Hi, > > I' m trying to set up a system using SQLite with ODBC interface on > Windows XP Embedded and trying to understand which types of actions I > have to do on my software to prevent data corruption during a power > loss. > > I set up a test system writing continuosly on database ( transactions > with 4 insert each one ) and stopping it with power losses. After 100 > stops task did not work properly because a rollback was performed on a > table ( this can be managed changing sotware). After others 20 stops > database was corrupted with "database disk image is malformed". > > I want to try same tests with PRAGMA journal_mode=PERSIST and try to > understand how and if the corruption frequency depends on file > dimension. > > Do you have other suggestions? > Any help would be appreciated >
Have you read this document: http://www.sqlite.org/atomiccommit.html D. Richard Hipp [EMAIL PROTECTED] _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
