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
