On 01/02/2014 02:47 AM, Kelvin Chua wrote:To be honest, no, I don't think it's worth a feature request, because the complications of implementing something like this are not justified by the effectiveness of the solutions it offers to the sorts of problems you're identifying.
agreed. the design of the db and queries are all properly tested, with
only milliseconds of query time even for tables as large as millions of
rows. i wanted to implement this only for insurance and was wondering if
it's doable, theoretically speaking.
the timer module is promising although lacks dynamic assignment of
timeouts. what i have in mind is:
- do a timer_enable() after receiving an INVITE.
- on timeout, go to rourte[timeout], statelessly send a cancel to
callee(if applicable) and 408 to caller.
- OR upon getting a 200 OK from the callee's leg, disable the timer.
- do you think this is worthy of a feature request? something like
timer_enable(timer_id, enable_disable, timeout)
Since you mentioned sql_xquery(), it's worth noting that some of the database connector modules (e.g. db_mysql) offer a query timeout parameter:
http://kamailio.org/docs/modules/4.1.x/modules/db_mysql.html#idp1968288
-- 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/
_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users