No, it will break when it gets too full. I've seend record lookups on sqlite take 15-20 SECONDS as it fills up
-----Original Message----- From: Stanislav German-Evtushenko [mailto:[email protected]] Sent: Friday, November 07, 2014 9:22 AM To: [email protected] Cc: [email protected]; Hunt, Phillip Subject: Re: [bareos-users] sqlite3 in production On Friday, November 7, 2014 5:17:54 PM UTC+3, Hunt, Phillip wrote: > Yes, sqlite is NOT a good database. Bareos writes millions of file records > to the file. Sqlite will run out of pointers and performance will greatly > suffer very quickly. > > Sqlite is a FLAT file database, not an indexed one. It simulates a database > so a developer does not have to figure out SQL/db setup stuff while > developing. So the only concern is performance. Am I right? This message (including any attachments) may contain confidential, proprietary, privileged and/or private information. The information is intended to be for the use of the individual or entity designated above. If you are not the intended recipient of this message, please notify the sender immediately, and delete the message and any attachments. Any disclosure, reproduction, distribution or other use of this message or any attachments by an individual or entity other than the intended recipient is prohibited. -- 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.
