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 thanks Olga This message (including any attachments) contains confidential and/or proprietary information intended only for the addressee. Any unauthorized disclosure, copying, distribution or reliance on the contents of this information is strictly prohibited and may constitute a violation of law. If you are not the intended recipient, please notify the sender immediately by responding to this e-mail, and delete the message from your system. If you have any questions about this e-mail please notify the sender immediately. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
