Re: [sqlite] integrity_check: Beating the system

2008-06-16 Thread Dan
> All: > I need to check a database for readability before my application > starts. I was originally going to keep an MD5 on the database and > check it each time at powerup. This seems to take a great deal of > time so instead I thought abou having the database do an integrity > check at power

Re: [sqlite] integrity_check: Beating the system

2008-06-16 Thread Rich Rattanni
> Couldn't you go ahead and do your quick check on startup and then do the > integrity check later when the database is otherwise unoccupied? I was thinking of doing a hybrid as you suggested. > If your database is smaller than system memory then there is also value > in just reading the entire f

Re: [sqlite] integrity_check: Beating the system

2008-06-16 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Rich Rattanni wrote: > This seems to take a great deal of > time so instead I thought abou having the database do an integrity > check at powerup, however this too takes a great deal of time. Couldn't you go ahead and do your quick check on startup

[sqlite] integrity_check: Beating the system

2008-06-16 Thread Rich Rattanni
All: I need to check a database for readability before my application starts. I was originally going to keep an MD5 on the database and check it each time at powerup. This seems to take a great deal of time so instead I thought abou having the database do an integrity check at powerup, however th