Re: [SR-Users] High performance routing options

2010-09-07 Thread Henning Westerholt
On Monday 06 September 2010, Alex Balashov wrote: > We use this in our solutions and search hundreds of millions of routes > with it in 2-3 ms. It works very well, to say the least, because it > is an approach that allows application of complex business logic > (using stored procedures) to the res

Re: [SR-Users] High performance routing options

2010-09-06 Thread Juha Heinanen
Jiri Kuthan writes: > good news is my company has a solution that can handle this easily > -- it can be configured to handle routing tasks of complex structures > at high speed even with large tables. bad news is it is not available > open-source :( jiri, you should know that it is not appropria

Re: [SR-Users] High performance routing options

2010-09-06 Thread Alex Balashov
On 09/06/2010 01:35 PM, anthony thomas wrote: I am surprise that you get such a performance with store procedures, what RDBM are you using? PostgreSQL. My response was to Daniel's link to the 'prefix' operator class module, which is for Postgres only. -- Alex Balashov - Principal Evariste

Re: [SR-Users] High performance routing options

2010-09-06 Thread anthony thomas
hat RDBM are you using? --- On Mon, 9/6/10, Alex Balashov wrote: > From: Alex Balashov > Subject: Re: [SR-Users] High performance routing options > To: "Daniel-Constantin Mierla" > Cc: "sr-users@lists.sip-router.org" > Date: Monday, September 6, 2010, 12:5

Re: [SR-Users] High performance routing options

2010-09-06 Thread Alex Balashov
We use this in our solutions and search hundreds of millions of routes with it in 2-3 ms. It works very well, to say the least, because it is an approach that allows application of complex business logic (using stored procedures) to the results, something which is much harder with a more p

Re: [SR-Users] High performance routing options

2010-09-06 Thread anthony thomas
Thanks Daniel, Looks interesting too, I will test it as well and will post the results regards, --- On Mon, 9/6/10, Daniel-Constantin Mierla wrote: From: Daniel-Constantin Mierla Subject: Re: [SR-Users] High performance routing options To: "anthony thomas" Cc: sr-users@lists.sip-

Re: [SR-Users] High performance routing options

2010-09-06 Thread Daniel-Constantin Mierla
Hello, On 9/6/10 5:03 PM, anthony thomas wrote: Hi everyone, 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 h

Re: [SR-Users] High performance routing options

2010-09-06 Thread anthony thomas
Hello Henning --- On Mon, 9/6/10, Henning Westerholt wrote: > On Monday 06 September 2010, anthony > thomas wrote: > > Yes, Indeed we are thinking in using postgres (we > already use it for our > >  backoffice databases). > > > > This sencente confuses me a little bit: > > Hello Anthony, > >

Re: [SR-Users] High performance routing options

2010-09-06 Thread Daniel-Constantin Mierla
Hello, On 9/6/10 6:01 PM, Henning Westerholt wrote: On Monday 06 September 2010, anthony thomas wrote: Yes, Indeed we are thinking in using postgres (we already use it for our backoffice databases). This sencente confuses me a little bit: Hello Anthony, > "some database which supports

Re: [SR-Users] High performance routing options

2010-09-06 Thread Henning Westerholt
On Monday 06 September 2010, anthony thomas wrote: > Yes, Indeed we are thinking in using postgres (we already use it for our > backoffice databases). > > This sencente confuses me a little bit: Hello Anthony, > "some database which supports proper prefix matching (i think postgres is > able

Re: [SR-Users] High performance routing options

2010-09-06 Thread anthony thomas
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

Re: [SR-Users] High performance routing options

2010-09-06 Thread Jiri Kuthan
good news is my company has a solution that can handle this easily -- it can be configured to handle routing tasks of complex structures at high speed even with large tables. bad news is it is not available open-source :( -jiri anthony thomas wrote: Hi everyone, We are looking at offloading ro

Re: [SR-Users] High performance routing options

2010-09-06 Thread Henning Westerholt
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 b

[SR-Users] High performance routing options

2010-09-06 Thread anthony thomas
Hi everyone, 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