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 ------------------------------------------------------- This SF.Net email is sponsored by the JBoss Inc. Get Certified Today * Register for a JBoss Training Course Free Certification Exam for All Training Attendees Through End of 2005 Visit http://www.jboss.com/services/certification for more information _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
