[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
well.
=====
Chris Albertson
Home: 310-376-1029 chrisalbertson90278 at yahoo.com
Cell: 310-990-7550
Office: 310-336-5189 Christopher.J.Albertson at aero.org
KG6OMK
__________________________________
Do you Yahoo!?
Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
http://hotjobs.sweepstakes.yahoo.com/signingbonus
More information about the asterisk-dev
mailing list