Re: [SR-Users] understanding the sqlops module and kamailio children.

Hello Uri, On 02/13/2014 11:57 AM, Uri Shacked wrote: These parameters are managed by the underlying DB driver (e.g. db_mysql, db_postgres), not sqlops. Sqlops just runs on top of those low-level database interface modules. So, for MySQL, you'd set these here: http://kamailio.org/docs/modules/4.1.x/modules/db_mysql.html#idp1968288 Unfortunately, the database modules are not consistent in the extent or granularity of timeout, keepalive and automatic reconnect-related options they offer. For example, db_mysql offers all of the options you see in the link above, but db_postgres does not. The answer to your second question is that yes, database operations block the current SIP worker thread, just as almost all external operations do. So, you definitely want your database queries to be fast and to return quickly. -- Alex -- Alex Balashov - Principal Evariste Systems LLC 235 E Ponce de Leon Ave Suite 106 Decatur, GA 30030 United States Tel: +1-678-954-0670 Web: http://www.evaristesys.com/, http://www.alexbalashov.com/