On Friday 07 November 2014 07.40:54 Stanislav German-Evtushenko wrote: > 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 > > > 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 > > selection > > I have many production systems based on sqlite3. > One of them is bacula with 200Mb database at the moment.
A 200MB database ? :-) We are playing with GB or TB database size and TB to PB in term of data volume. With several clients multi-platform and several sd with multiple kind of device. Once you will get half of those number you just will see sqlite burning ;-) -- Bruno Friedmann Ioda-Net Sàrl www.ioda-net.ch openSUSE Member & Board, fsfe fellowship GPG KEY : D5C9B751C4653227 irc: tigerfoot -- You received this message because you are subscribed to the Google Groups "bareos-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. For more options, visit https://groups.google.com/d/optout.
