<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:times new roman,new york,times,serif;font-size:12pt"><div>Hi Henning,<br><br>Yes, Indeed we are thinking in using postgres (we already use it for our backoffice databases). <br><br>This sencente confuses me a little bit:<br><br> "some database which supports proper prefix matching (i think postgres is able to do this)"<br><br>Once the db is loaded, the prefix matching is done in memory, right?<br><br>And I am not following you here:<br>"with some queries in the script instead of a custom module?"<br>
<br>Thanks,<br><br>A <br></div><div style="font-family: times new roman,new york,times,serif; font-size: 12pt;"><br><div style="font-family: arial,helvetica,sans-serif; font-size: 13px;"><font size="2" face="Tahoma"><hr size="1"><b><span style="font-weight: bold;">From:</span></b> Henning Westerholt <henning.westerholt@1und1.de><br><b><span style="font-weight: bold;">To:</span></b> sr-users@lists.sip-router.org<br><b><span style="font-weight: bold;">Cc:</span></b> anthony thomas <g00tyou@yahoo.com><br><b><span style="font-weight: bold;">Sent:</span></b> Mon, September 6, 2010 5:33:36 PM<br><b><span style="font-weight: bold;">Subject:</span></b> Re: [SR-Users] High performance routing options<br></font><br>
On Monday 06 September 2010, anthony thomas wrote:<br>> We are looking at offloading routing logic out of our existing softswitch<br>> using openser as an external redirect server. Our routing logic is not<br>> terribly complicated and I think both carrierroute and LCR modules would<br>> be able to handle it but we have a pretty large route list table with<br>> around 30 million records (our routing table is 300k codes but keep<br>> different tables per client), 25-30 calls per sec would be enough.<br>> <br>> From a performance point of view, what would be the best bet within both<br>> modules? also, are both modules actively maintained?<br><br>Hi Anthony,<br><br>both modules are actively maintained, in the case of cr this is done from us. <br>30 Million records is indeed a bit larger.. For cr the biggest usage i heard <br>was something like 1 Million routing rules in one instance.<br><br>Have you maybe also thought about using
some database which supports proper <br>prefix matching (i think postgres is able to do this) with some queries in the <br>script instead of a custom module?<br><br>If you don't want to trust a database in this regards, there is also the pdb <br>module available which supports huge data sets for prefix matching with a <br>custom server. With the included data "compiler" you can also do prefix <br>optimisation to save memory, its able to store a number portability database <br>for a country like germany in a few hundreds MB of RAM.<br><br>Cheers,<br><br>Henning<br></div></div>
</div><br>
</body></html>