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

[Miha]

yes. I have in redis like: KEY (DID) and VALUE (NETID), than I am doing 
lookup in opensips script.

  I was looking what is the most a appropriate way to do this. As redis 
is quite good in this cases I choose it but the issue is memory :(


tnx

miha


On 12/10/2016 14:25, Bogdan-Andrei Iancu wrote:
> So basically you need to determine the NET_ID based on the DID number 
> ? this is what you do in REDIS now ?
>
> Regards,
>
> Bogdan-Andrei Iancu
> OpenSIPS Founder and Developer
> http://www.opensips-solutions.com
>
> On 12.10.2016 15:09, Miha wrote:
>> Hi Bogdan
>>
>> i missed your email, sorry...
>>
>> Operator need to have number like NET_ID + DID. So routing is based 
>> on NET_ID. I manage to get all number in redis (quite a big amount of 
>> memory is used :) ).So first I do lookup in redis, get NET_ID and 
>> then I am using d_routing based od NET_IDs.
>>
>> br
>> miha
>> On 05/10/2016 15:17, Bogdan-Andrei Iancu wrote:
>>> Hi Miha,
>>>
>>> so you have 120M records (NET_ID + DID) - how do you use them from 
>>> OpenSIPS ? As I fail to understand what are the operations you want 
>>> to perform over this data.
>>>
>>> Regards,
>>>
>>> Bogdan-Andrei Iancu
>>> OpenSIPS Founder and Developer
>>> http://www.opensips-solutions.com
>>>
>>> On 05.10.2016 09:44, 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
>>>>
>>>
>>>
>>
>
>