Nick Shaw <nick.s...@citysync.co.uk> wrote:
>> Do you really want SQLite to scan a gigabytes-large file every time it's 
>> opened?
> 
> Depends - obviously not if you need quick access to the data, however if
> the gigabytes-large file is corrupt, do you really want to wait until
> you execute the first "substantive" statement to discover the DB is
> corrupt?

You won't even necessarily know at this point. Only when one of your statements 
actually hits the corrupted part.
-- 
Igor Tandetnik

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to