<div dir="ltr"><font><font face="verdana,sans-serif">Greetings,</font></font><div><font><font face="verdana,sans-serif"><br></font></font></div><div><font><font face="verdana,sans-serif">Thanks for the helpful replies. Presently, the list of gateways cannot be retrieved using a direct query on the external database, and hence I need the Perl script to act as the middle-ware too. Some changes in the external database may fix this, and then I would be able to use the </font></font><font face="courier new, monospace">avops</font><font face="verdana, sans-serif"> module as Ali suggested, </font><span style="font-family:verdana,sans-serif">but I need to first thoroughly study all the consequences ...</span></div>
<div><font><font face="verdana,sans-serif"><br></font></font></div><div><font><font face="verdana,sans-serif">Regarding the bottleneck issue, I don't see any way that I can avoid the queries (or Perl). In case it turns out to be a real bottleneck, then is there any way to go around it, or will I actually be hitting an OpenSIPS limitation?</font></font></div>
<div><font><font face="verdana,sans-serif"><br></font></font></div><div><font><font face="verdana,sans-serif">Cheers,</font></font></div><div><font><font face="verdana,sans-serif">Shaahin</font></font></div><div><font><font face="verdana,sans-serif"><br>
</font></font></div><div><font face="verdana, sans-serif">P.S. [to Ali and Rudy]: It's "Shaahin", not "Shaheen" :-)</font></div><div><font><font face="verdana,sans-serif"><br></font></font></div><div>
<font><font face="verdana,sans-serif"><br></font></font><br><div class="gmail_quote">On Fri, Aug 31, 2012 at 2:03 AM, Rudy <span dir="ltr"><<a href="mailto:rudy@dynamicpacket.com" target="_blank">rudy@dynamicpacket.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Brett,<br>
<br>
Any complex logic, perl, sql or otherwise can impact performance and<br>
create a bottleneck. Regarding the perl module in particular, I can<br>
tell you that it works pretty well.<br>
<br>
Thanks in advance,<br>
<div class="im HOEnZb">--Rudy<br>
Dynamic Packet<br>
Toll-Free: 888.929.VOIP ( 8647 )<br>
<br>
<br>
</div><div class="HOEnZb"><div class="h5">On Thu, Aug 30, 2012 at 11:58 AM, Brett Nemeroff <<a href="mailto:brett@nemeroff.com">brett@nemeroff.com</a>> wrote:<br>
> If you can sum up the logic in an SQL query I'd recommend doing that. If you<br>
> can cache the results in memcache, even better. Just keep in mind that any<br>
> complicated logic can serve as a significant bottleneck. Depending on your<br>
> traffic load, that may or may not be an issue.<br>
><br>
> I know there are a few recommendations for the perl module here, but I'm not<br>
> sure of the status of the module and if it's actively maintained. I'd love<br>
> to hear from others about their own experiences using it. I haven't used it<br>
> myself in maybe 6 years or so.<br>
> -Brett<br>
><br>
><br>
> On Thu, Aug 30, 2012 at 9:09 AM, Shaahin Madani <<a href="mailto:shaahin.madani@gmail.com">shaahin.madani@gmail.com</a>><br>
> wrote:<br>
>><br>
>> Hi Bogdan and Brett,<br>
>><br>
>> Thanks for your replies. The issue here is that my OpenSIPS simply does<br>
>> not have the list of gateways, that is the gateways are *not* available in<br>
>> the dr_gateways table. For every INVITE request, the list of gateways must<br>
>> be dynamically built, and only afterwards the actual dynamic routing can<br>
>> take place. The logic behind building the list of gateways relies on a<br>
>> totally separate database.<br>
>> To sum it up, I would say the desired scenario would resemble the steps<br>
>> below:<br>
>><br>
>> 1) OpenSIPS receives an INVITE<br>
>> 2) OpenSIPS asks an external system (e.g. the Perl script) for the<br>
>> gateways available for this specific INVITE request<br>
>> 3) A list of gateways is returned to OpenSIPS (based on some black-box<br>
>> logic)<br>
>> 4) OpenSIPS dynamically routes the INVITE to the specified gateways,<br>
>> prioritising based on cost, time, or ...<br>
>><br>
><br>
</div></div><div class="HOEnZb"><div class="h5">> _______________________________________________<br>
> Users mailing list<br>
> <a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br>
> <a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
><br>
<br>
_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
</div></div></blockquote></div><br></div></div>