[SR-Users] Database Insert
Daniel W. Graham
dan at cmsinter.net
Tue Feb 16 22:46:52 CET 2016
Ok, just making sure I was on the same page :)
Thanks for the link to the article, looks like a good read!
From: sr-users [mailto:sr-users-bounces at lists.sip-router.org] On Behalf Of Alex Balashov
Sent: Tuesday, February 16, 2016 4:31 PM
To: sr-users at lists.sip-router.org
Subject: Re: [SR-Users] Database Insert
On 02/16/2016 04:27 PM, Daniel W. Graham wrote:
> Well I assume either way would work, is there that big of performance
> hit by using sql_query?
That depends on how long the INSERT statement takes to return. :-) In principle, it shouldn't be a big deal.
sql_query_async() is just a wrapper around something very similar to the mqueue/rtimer example I gave in the previous post. It's just more streamlined.
As far as whether there's a performance hit, that's a complex discussion. Any external I/O wait incurs some delay, but whether it's significant or whether it's worth doing anything about it is hard to say.
As it happens, I just wrote an article on this topic last night:
Alex Balashov | Principal | Evariste Systems LLC
303 Perimeter Center North, Suite 300
Atlanta, GA 30346
Tel: +1-800-250-5920 (toll-free) / +1-678-954-0671 (direct)
Web: http://www.evaristesys.com/, http://www.csrpswitch.com/
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users at lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
More information about the sr-users