Yuval Abadi wrote:
I run sqlite in command line application and from some reason CTRL+C is
call while writing to data base.
I use asynchronies NORMAL.. (FULL is not possible because performance
drawbacks)
The "PRAGMA synchronous" setting is only important for recovery
from power failures and OS crashes. It should not matter here.
On the other hand, the difference between NORMAL and FULL should be
minimal. What kind of performance impact are you seeing?
When I rerun my application I cannot load the data base file. (also
sqlite_shell is failed to load) and pragma integrity check cause
exception in sqlite dll.
My os is win2k.
Does any one know how to recover DB file?
The sqlite.exe shell automatically attempts to recover the
database when it runs. If sqlite.exe failed, then the
database is unrecoverable.
My guess is that a stray pointer or buffer overrun in your
larger program overwrote some data structure inside of the
SQLite library, thus causing SQLite to malfunction, corrupt
the database, and crash.
--
D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
