[OpenSIPS-Users] LCR Route Prefixes -> Gateways (From Scratch)

[Muhammad Shahzad Shafi]

You should worry about it when you have 1M+ records. :-)

But anyways, if you are a good DBA or know a good DBA, then just have a 
look at SQL queries made by opensips to db tables and optimize them as 
needed and create appropriate indexes etc. Though that may not be 
necessary, as i think they are pretty much optimized already but just 
for sake of confidence you can check them. Don't forget to share those 
optimized queries with this forum here, so opensips developers may 
include them in next release. :-)

Thank you.


On 2013-08-02 03:13, Nick Khamis wrote:
> Muhammad this email slipped through my list, and I am glad I saw your
> response. For this particular OpenSIPS instance, all routes will be
> service provider bound. Looking at the carrierroute module, it does
> seem like it has not been maintained in a while, and that's part of
> the reason I reached out to the list.
>
> What I am worried about is the how the DR module would scale vs
> Carrier. As you know :), these will be lists of ~60,000 prefixes per
> service provider, and we will keep appending to it whenever we take 
> on
> a new interconnection agreement.
>
> Kind Regards,
>
> Nick.
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users

-- 
Mit freundlichen Grüßen
Muhammad Shahzad
-----------------------------------
CISCO Rich Media Communication Specialist (CRMCS)
CISCO Certified Network Associate (CCNA)
Cell: +49 176 99 83 10 85
MSN: shari_786pk at hotmail.com
Email: shaheryarkh at googlemail.com