[SR-Users] High performance routing options

[anthony thomas]

Hi Henning,

Yes, Indeed we are thinking in using postgres (we already use it for our 
backoffice databases).

This sencente confuses me a little bit:

 "some database which supports proper prefix matching (i think postgres is able 
to do this)"

Once the db is loaded, the prefix matching is done in memory, right?

And I am not following you here:
"with some queries in the script instead of a custom module?"

Thanks,

A




________________________________
From: Henning Westerholt <henning.westerholt at 1und1.de>
To: sr-users at lists.sip-router.org
Cc: anthony thomas <g00tyou at yahoo.com>
Sent: Mon, September 6, 2010 5:33:36 PM
Subject: Re: [SR-Users] High performance routing options

On Monday 06 September 2010, anthony thomas wrote:
> We are looking at offloading routing logic out of our existing softswitch
> using openser as an external redirect server. Our routing logic is not
> terribly complicated and I think both carrierroute and LCR modules would
> be able to handle it but we have a pretty large route list table with
> around 30 million records (our routing table is 300k codes but keep
> different tables per client), 25-30 calls per sec would be enough.
> 
> From a performance point of view, what would be the best bet within both
> modules? also, are both modules actively maintained?

Hi Anthony,

both modules are actively maintained, in the case of cr this is done from us. 
30 Million records is indeed a bit larger.. For cr the biggest usage i heard 
was something like 1 Million routing rules in one instance.

Have you maybe also thought about using some database which supports proper 
prefix matching (i think postgres is able to do this) with some queries in the 
script instead of a custom module?

If you don't want to trust a database in this regards, there is also the pdb 
module available which supports huge data sets for prefix matching with a 
custom server. With the included data "compiler" you can also do prefix 
optimisation to save memory, its able to store a number portability database 
for a country like germany in a few hundreds MB of RAM.

Cheers,

Henning



      
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20100906/3768a3c3/attachment.htm>