[Asterisk-Dev] Current database abstraction effort ?

Chris Albertson chrisalbertson90278 at yahoo.com
Mon Jan 5 22:35:17 MST 2004

> MySQL can do 3000-4000 inserts a second on a tiny 1ghz box with IDE.
> the
> ODBC tax drops that to the 700-1000 range.(and this is because the
> isql
> util SUCKS)  To get true more realistic stats I would have to write
> something in C to test it.

So we all agree that Asterisk would be grossly overloaded long befor
ODBC performance becomes an issue  It would take a prety large PBX
to generate even 100 inserts/sec.  10/sec is a more realistic number
for a moderate sized system.

My bechmarking shows that MySQL does in fact do a few thousand
inserts per second _IF_ there are no other processes accessing the
same tables AND you are not enforcing things like constraints
and mainting indexes.
If there are other users doing 4-way joins or some
other complex selects on the tables the insert rate goes way down
sometimes to zero/second  It does not handle concurrent access very

Chris Albertson
  Home:   310-376-1029  chrisalbertson90278 at yahoo.com
  Cell:   310-990-7550
  Office: 310-336-5189  Christopher.J.Albertson at aero.org

Do you Yahoo!?
Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes

More information about the asterisk-dev mailing list