[Asterisk-Dev] Current database abstraction effort ?

[Brian West]

> I think you need to examine normal installs and performance here. While
> the ODBC portion may not have a problem moving 100 records a second,
> quite a few DBs have problems when you do that kind of insert load on
> them. Specifically I would never bet the farm on MySQL holding up to
> that. I would probably still be uneasy suggesting that Postgres would do
> it on the hardware most people would send it's way.
>
> Don't take this as a disparaging thought about ODBC, just wanting to
> bring some reality back to the questions.

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.

bkw