Zitat von Stanislav German-Evtushenko <[email protected]>:
On Friday, November 7, 2014 6:09:52 PM UTC+3, Hunt, Phillip wrote:As I said, being a flat keyed system, sqlite will have sever performance problems,This is not that obvious: http://www.sqlite.org/cvstrac/wiki?p=SpeedComparison
Simple operations in simple environments are fast, that's what i have said...
And eventually break due to the number of records written. If you backup a million files, you have just written a million records to the db.I've been running for 3 weeks, and my postgresql db is 988 meg. Imagine that as a flat system lookup for each file to determine an incr backup selectionI have many production systems based on sqlite3. One of them is bacula with 200Mb database at the moment.
If your are confident that it works in your case use it, but warranty is void. If you might need to scale to concurrent jobs with TB of data and millions of files per backup you should think twice about.
That's all from me on this topic Regards Andreas
smime.p7s
Description: S/MIME Cryptographic Signature
