[Freeswitch-users] Mod LCR SQL sub-query for better routing

[Ken Rice]

You should never simply re-order just by rate... When you select the rate
for the route you _must_ select the longest prefix... You can just fall back
to 1 since it matches 1876 also... This is not valid just for non-US areas
in NANPA but for globally... Its not uncommon to see something like +44 @
0.0095 (UK London Landline)  then see something like +447938 @ 0.0150 (O2
Mobile) if you tried to route this off the cheapest prefix you would always
be doing it wrong...

And don¹t even get started with ignoring things like LRN in the US with a
ratedeck that has per NPA-NXX(-X) pricing while respecting LRN


On 12/16/13 5:36 PM, "DP ." <hi-tecc at hotmail.com> wrote:

> I agree. This definitely sounds like he simply needed the "reorder_by_rate"
> param. It will reorder the initial sql results strictly by rate:
> 
> * reorder_by_rate - Forces the LCR module to re-order the query strictly on
> rate basis. By default this is turned off, but enabling this will always
> prefer rate over anything else.
> 
> Beware this may have an adverse effect! I initially had this turned on then
> quickly realized it would sometimes try to route ALL calls by the lowest rate
> found. 
> 
> Ex: flowroute lists all calls for the US with a default NPA of "1" at .0098.
> Now a user trying to call Jamaica with "1876" at a rate of 0.19 (or whatever)
> will get both flowroute rates returned. The reorder by rate will assume 0.0098
> is a valid rate since it will now be the "cheapest" in the list and send the
> call along its way to flowroute, whom will now bill you at 0.19. Now if you
> have another carrier in your list with 1876 at 0.15 you can see why this would
> be a problem.
> 
> In this case you will always want the longest matched NPANXX rate.
> 
> 
> Date: Fri, 13 Dec 2013 15:58:54 -0500
> From: intralanman at freeswitch.org
> To: freeswitch-users at lists.freeswitch.org
> Subject: Re: [Freeswitch-users] Mod LCR SQL sub-query for better routing
> 
>      
> On 12/12/2013 02:42 PM, Victor Chukalovskiy wrote:
>  
>  
>>  
>> Hello,
>> 
>> For those interested, I added a piece to mod lcr wiki. It makes sorting
>> / routing logic better than default logic:
>> 
>> http://wiki.freeswitch.org/wiki/Mod_lcr#Custom_SQL_with_sub-query_-_for_real-
>> life_ratesheet_complexities
>> 
>> Why it helps:
>> 
>> Rates rates can often be given both on per-NPA or per-NPANXX level
>> depending on the carrier and on the NPA. Moreover, some carriers may
>> have NPANXX rate lower than the corresponding NPA rate, while others
>> will have it inverse. Neither simple ORDER BY rate, prefix; nor ORDER BY
>> prefix, rate; give the truly cheapest route. The LCR logic should be
>> two-step process to accommodate this.
>> 
>> Cheers,
>> -Victor
>>  
>  Unless I misunderstand what you're saying, this is what the reorder_by_rate
> param does.
>  
>  You'll always want to pick the longest digit match per carrier.  Then you
> probably want to grab the cheapest overall rate of the matches you got back.
>  
>  -Ray
>  
>      
> _________________________________________________________________________
> Professional FreeSWITCH Consulting Services: consulting at freeswitch.org
> http://www.freeswitchsolutions.com FreeSWITCH-powered IP PBX: The CudaTel
> Communication Server  Official FreeSWITCH Sites
> http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
> FreeSWITCH-users mailing list FreeSWITCH-users at lists.freeswitch.org
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> http://www.freeswitch.org
>        
> 
> 
> _________________________________________________________________________
> Professional FreeSWITCH Consulting Services:
> consulting at freeswitch.org
> http://www.freeswitchsolutions.com
> 
> 
> 
> 
> Official FreeSWITCH Sites
> http://www.freeswitch.org
> http://wiki.freeswitch.org
> http://www.cluecon.com
> 
> FreeSWITCH-users mailing list
> FreeSWITCH-users at lists.freeswitch.org
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> http://www.freeswitch.org

-- 
Ken
http://www.FreeSWITCH.org
http://www.ClueCon.com
http://www.OSTAG.org
irc.freenode.net #freeswitch
Twitter: @FreeSWITCH


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20131216/d293b552/attachment.html