[OpenSIPS-Users] Help with big amount of data for routing

Miha miha at softnet.si
Wed Oct 5 09:16:23 CEST 2016


Hi Alex

i tried, but mysql takes so long time for every select. What do u have 
in mind?


tnx

miha


On 05/10/2016 08:46, Alex Balashov wrote:
> Why do you believe that using a traditional RDBM necessarily means 
> slow lookups?
>
> On 10/05/2016 02:44 AM, Miha wrote:
>
>> HI
>>
>> the is not really opensips issue:) I need somehow to store big amount of
>> data for routing.
>>
>> To every telephone operator I must send RURI like
>> Net_ID+Telephone_number (value indicates to who number belongs to). In
>> this country they have around 120 millions of numbers.
>>
>> After i have all NET_IDs with numbers I will use drouting for routing
>> numbers to right operator based on NET_ID.
>>
>> Here is the issue:
>> - I tried this with redis (lookup must be quick) but this takes so much
>> memory that basically redis brakes everytime in between 50 millions and
>> 70 millions entries
>> - I tried with hash (hset) in redis but did not do any good
>>
>>
>> Do you have any suggestion how to deal with this, what would be the best
>> thing to use?
>>
>>
>>
>> tnx
>>
>> miha
>>
>>
>> _______________________________________________
>> Users mailing list
>> Users at lists.opensips.org
>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>




More information about the Users mailing list