[Freeswitch-dev] ODBC pooling

[Erjan Tylepov]

Hi all,

Do I correctly understand, that mod_nibblebill (as of Feb 17 commit: b05ca56adf2dd8f9b0bbf114827de98aec8313ae) have a bottle neck with db connections? I.e. when there will be a number of calls bill_event and get_balance functions will hangup until after all the threads, executing the functions, will do their jobs with db or, even worse, negatively influence each other?

Is this sequence is a right one in the aforesaid functions:
switch_odbc_handle_new
switch_odbc_handle_connect
switch_odbc_handle_exec (in bill_event)
switch_odbc_statement_handle_free (in bill_event)
switch_odbc_handle_callback_exec (in get_balance)
switch_odbc_handle_disconnect?

If yes, where can I set pool size?

Regards,
YT.