[Freeswitch-users] High load on database server

[Cliff Wells]

On Thu, 2011-10-27 at 11:55 -0400, Madovsky wrote:
> I means that depend the quality of your script ;)

Quality isn't the issue here.  The script is too simple to be incorrect
(and it carefully releases the odbc connection back to the pool in a
hangup handler).  I have written poor-quality code plenty of times, but
25 years as a programmer usually allows me the luxury of knowing when
I'm doing it, thanks.

In any case, Lua scripts work fine.  Google will tell you that unixODBC
before 2.3.0 was a bit of a mess, so I expect the issue lies there, but
again, I emphasize, everything WORKS GREAT (been using it for a couple
of years now) until you get to very high concurrency (about 330
concurrent calls on a single system).  If you don't expect to handle
more than 300 concurrent calls, then you do not need to worry about it.
At all.

Regards,
Cliff