<html><head></head><body><div style="font-family:Helvetica Neue, Helvetica, Arial, sans-serif;font-size:16px;"><div></div>
<div>Awesome. Will I take a huge performance hit if I I dip to DB on every call. e.g </div><div><br></div><div> <span><span style="font-family: "Helvetica Neue", Helvetica, Arial, sans-serif;">request_route {</span><br clear="none" style="font-family: "Helvetica Neue", Helvetica, Arial, sans-serif;"><span style="font-family: "Helvetica Neue", Helvetica, Arial, sans-serif;"> # Initialize AVPs needed for the call.</span></span></div><div><span> # call usp that returns calltype and other items<br clear="none" style="font-family: "Helvetica Neue", Helvetica, Arial, sans-serif;"> <span>sql_xquery("ca","call usp_classcall '$fU' , '$fd';", "ra");</span><br><br><br clear="none" style="font-family: "Helvetica Neue", Helvetica, Arial, sans-serif;"><span style="font-family: "Helvetica Neue", Helvetica, Arial, sans-serif;"> $avp(call_type) = <span>$xavp(ra=>callType)</span>;</span></span></div><div><span> <span><span style="color: rgb(0, 0, 0); font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 16px;">$avp(goodies1) = <span><span style="color: rgb(0, 0, 0); font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 16px;">$xavp(ra=> <span><span style="color: rgb(0, 0, 0); font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 16px;">goodies1</span></span>)</span></span>;</span></span></span></div><div><span><span><span style="color: rgb(0, 0, 0); font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 16px;"> $avp( <span><span style="color: rgb(0, 0, 0); font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 16px;">goodies2</span></span>) = <span><span style="color: rgb(0, 0, 0); font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 16px;">$xavp(ra=> <span><span style="color: rgb(0, 0, 0); font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 16px;">goodies2</span></span>)</span></span>;</span></span><br clear="none" style="font-family: "Helvetica Neue", Helvetica, Arial, sans-serif;"><span><span style="color: rgb(0, 0, 0); font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 16px;"> $avp( <span><span style="color: rgb(0, 0, 0); font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 16px;">goodies3</span></span>) = <span><span style="color: rgb(0, 0, 0); font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 16px;">$xavp(ra=> <span><span style="color: rgb(0, 0, 0); font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 16px;">goodies3</span></span>)</span></span>;</span></span><br clear="none" style="font-family: "Helvetica Neue", Helvetica, Arial, sans-serif;"><span style="font-family: "Helvetica Neue", Helvetica, Arial, sans-serif;"> </span></span></div><div><span> <span>sql_result_free("ra");</span><br clear="none" style="font-family: "Helvetica Neue", Helvetica, Arial, sans-serif;"><br clear="none" style="font-family: "Helvetica Neue", Helvetica, Arial, sans-serif;"><span style="font-family: "Helvetica Neue", Helvetica, Arial, sans-serif;"> </span><br clear="none" style="font-family: "Helvetica Neue", Helvetica, Arial, sans-serif;"><span style="font-family: "Helvetica Neue", Helvetica, Arial, sans-serif;"> }</span></span></div><div><span><span style="font-family: "Helvetica Neue", Helvetica, Arial, sans-serif;"><br></span></span></div><div><span><span style="font-family: "Helvetica Neue", Helvetica, Arial, sans-serif;">Will DB hits on every call hinder performance. </span></span></div><div><br></div>
<div id="yahoo_quoted_7214552609" class="yahoo_quoted">
<div style="font-family:'Helvetica Neue', Helvetica, Arial, sans-serif;font-size:13px;color:#26282a;">
<div>
On Monday, May 14, 2018, 10:03:04 AM EDT, Alex Balashov <abalashov@evaristesys.com> wrote:
</div>
<div><br></div>
<div><br></div>
<div>I think your best bet is to set those variables as AVPs, so that their<br clear="none">values can persist throughout the lifetime of the INVITE transaction.<br clear="none">That way you can also access them in onreply_route and failure_route,<br clear="none">which would not be the case with user variables ($var(...)). <br clear="none"><br clear="none"> request_route {<br clear="none"> # Initialise AVPs to $null or presumed default value.<br clear="none"><br clear="none"> $avp(call_type) = $null;<br clear="none"><br clear="none"> ...<br clear="none"><br clear="none"> # When determination is made as to the call type:<br clear="none"><br clear="none"> if($dbr(res=>[0,0]) eq 'vm')<br clear="none"> $avp(call_type) = 'voicemail';<br clear="none"> }<br clear="none"><br clear="none">-- Alex<br clear="none"><div class="yqt5130778680" id="yqtfd47403"><br clear="none">On Mon, May 14, 2018 at 01:56:53PM +0000, KamDev Essa wrote:<br clear="none"><br clear="none">> Being spoiled by Freeswitch profiles and dialplans, the stock 1 piece Kamailio cfg file is cool @ first to get certain call flows knocked out but quite a maze when you get in deeper. <br clear="none">> Right now, using the 1 piece stock cfg file, I am faced with the fact that my carrier outbound calls started failing after I enabled VM. Basically WITH_VOICEMAIL in route LOCATION started sending the carrier calls to TOVOICEMAIL and it basically dies there. I can see the route(TOVOICEMAIL) line and can condition it out with an if but I really don't now how to differentiate between a ext to ext call or a outbound call in the cfg file. However given SQL I could. <br clear="none">> Is there a way for me to place custom pseudo variables in the call right @ the start and use them in the script as needed. For example I could mark the call as ext to ext or carrier bound right @ the start and dodge VM in the LOCATION route. <br clear="none">> KD</div><br clear="none"><br clear="none">> _______________________________________________<br clear="none">> Kamailio (SER) - Users Mailing List<br clear="none">> <a shape="rect" ymailto="mailto:sr-users@lists.kamailio.org" href="mailto:sr-users@lists.kamailio.org">sr-users@lists.kamailio.org</a><br clear="none">> <a shape="rect" href="https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users" target="_blank">https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users</a><br clear="none"><br clear="none"><br clear="none">-- <br clear="none">Alex Balashov | Principal | Evariste Systems LLC<br clear="none"><br clear="none">Tel: +1-706-510-6800 / +1-800-250-5920 (toll-free) <br clear="none">Web: <a shape="rect" href="http://www.evaristesys.com/, " target="_blank">http://www.evaristesys.com/, </a><a shape="rect" href="http://www.csrpswitch.com/" target="_blank">http://www.csrpswitch.com/</a><br clear="none"><br clear="none">_______________________________________________<br clear="none">Kamailio (SER) - Users Mailing List<br clear="none"><a shape="rect" ymailto="mailto:sr-users@lists.kamailio.org" href="mailto:sr-users@lists.kamailio.org">sr-users@lists.kamailio.org</a><br clear="none"><a shape="rect" href="https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users" target="_blank">https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users</a><div class="yqt5130778680" id="yqtfd13705"><br clear="none"></div></div>
</div>
</div></div></body></html>