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