D. Richard Hipp [Sun, Feb 29, 2004 at 07:00:47PM -0500]: > >> 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.
Well, it seems my database file was too corrupted. I am examining this issue. How error-proof are sqlite internal structures in the database file? My point is, that only a few rows in one table were broken. Please also note, that I never assumed this is sqlite's fault - the computer the database was running on experienced a hard lock-up, was rebooted, the disk wasn't checked (Windows 98 + FAT32 fs); few rows contained corrupted data, other were pretty okay. Anyway, as I can't examine the machine, that was running the software, when the corruption occured - do this description of corrupted data matches the rollback bug you described? Thank you, -- mp --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
