Thanks for the feedback. I read someplace that the Berkeley DB was wicked fast and allowed for much higher concurrency. The only problem is that I have no idea how to implement it into Asterisk. Does anyone have any experience with something like this? Regards; John
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Chris Bagnall Sent: Thursday, October 03, 2013 1:25 PM To: [email protected] Subject: Re: [asterisk-users] Using sqlite3 for CDR logging On 3/10/13 5:52 pm, Tech Support wrote: >I was > thinking of using sqlite3 to log CDR's, thinking that would be faster than > using MySQL. Has anyone ever benchmarked this to quantify just how much > faster sqlite3 is? Are there any drawbacks to using it? Lack of multi-user concurrency is the big one. At the risk of encouraging database contests on the list, have you tried using PostgreSQL instead? It's a gross generalisation, but In my experience, PG handles writes better than MySQL, which in turn tends to handle reads a little faster than PG - assuming both are in 'out of the box' (i.e. unoptimised) conditions. If you wanted to stick with MySQL, you might want to have a go at optimising it - there are quite a few scripts knocking around the web which run a set of queries on your data and suggest optimisations to apply. And others have said, running the DB on a separate host is never a bad thing, and ideally on SSDs or RAM storage if you can. Spinning disks are often the bottleneck with large data sets. Kind regards, Chris -- This email is made from 100% recycled electrons -- _____________________________________________________________________ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users -- _____________________________________________________________________ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
