[SR-Users] High performance routing options

[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 proper prefix matching (i think postgres is
>>   able to do this)"
>>
>> Once the db is loaded, the prefix matching is done in memory, right?
> well, i think this depends on the database configuration and memory setup of
> the machine, but normally this is what you want. I was referring to the fact
> that in my experience one not insert complete number ranges in the database
> but certain prefixes, and then do a longest prefix match to find the optimal
> route. But of course you could do also something like this with some SQL.
>
>> And I am not following you here:
>> "with some queries in the script instead of a custom module?"
> I was referring to the setup you just described, use a standard DB with the a
> module like sqlops instead of something more specialized, e.g. cr.
For postgresql, here is a link to follow for more details:
http://prefix.projects.postgresql.org/

Cheers,
Daniel

-- 
Daniel-Constantin Mierla
http://www.asipto.com