D. Richard Hipp [Sun, Feb 29, 2004 at 06:20:36PM -0500]:
If you want to check for corruption in a database, do this:
PRAGMA integrity_check;
How long can it work?
Are you asking how long it takes to run?
On my 1.6GHz Athlon running RedHat 7.2, it takes about 20 seconds to verify a 100MB database that is not in cache. Once the database is in cache, it takes about 10 seconds. So pragma integrity_check will analyze between 5 and 10 MB/s. Your mileage may vary.
-- D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
