[asterisk-users] Using sqlite3 for CDR logging

[Tech Support]

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: asterisk-users-bounces at lists.digium.com
[mailto:asterisk-users-bounces at lists.digium.com] On Behalf Of Chris Bagnall
Sent: Thursday, October 03, 2013 1:25 PM
To: asterisk-users at lists.digium.com
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