From: Alan B. <aj...@ms...> - 2005-10-27 11:09:37
|
On Wed, 26 Oct 2005, Paul Heinlein wrote: > The danger is that a system crash can easily result in a wholly corrupted > database. In fact, the SQLite developers have removed this functionality from > version 3, calling it "dangerous." Make sure you read the documentation to > understand the dangers: Rather than using a stack of individual inserts, it'd be a big (and safer) gain to use transactions or batch inserts. Both MySQL and Postgres can do this in current versions. I don't know if SQlite has the functionality > The upside is that attribute spooling that used to take a couple days is now > done in a few hours. My weekly full backups used to take from Friday night > until Monday night; now they start Saturday evening and are finished about > the time I get my Sunday-morning coffee. My Full backups take 3-8 days but that's more a function of tape run time on 20Tb of disk. :-) AB |