<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p>Hello Grant,</p>
<p>they use a different internal structure (in case of the carrierroute/drouting a tree structure). In case of large route sets (like more than 10.000 up to a million entries).<br>
</p>
<p>But depending on your scenario (and the other queries that you already do in the cfg) you maybe also might consider to query directly the database for the routing information.
<br>
</p>
<p>Cheers,</p>
<p>Henning<br>
</p>
<div class="moz-cite-prefix">Am 10.09.19 um 09:59 schrieb Grant Bagdasarian:<br>
</div>
<blockquote type="cite" cite="mid:CACK6f-ru2MQVxWGtndxRuHu0e7b0FX0O4s3Y86L_u6h1bcw+eg@mail.gmail.com">
<div>
<div dir="auto">Hi Henning,</div>
</div>
<div dir="auto"><br>
</div>
<div dir="auto">Thanks for your reply.</div>
<div dir="auto">I figured the memory consumption and load times would increase as the tables grow. </div>
<div dir="auto"><br>
</div>
<div dir="auto">Are the carrierroute and drouting modules more efficient when it comes down to memory consumption and load times? </div>
<div dir="auto"><br>
</div>
<div dir="auto">Regards,</div>
<div dir="auto"><br>
</div>
<div dir="auto">Grant</div>
<div><br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Mon, 9 Sep 2019 at 21:46, Henning Westerholt <<a href="mailto:hw@skalatan.de" moz-do-not-send="true">hw@skalatan.de</a>> wrote:<br>
</div>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
Hello Grant,<br>
<br>
regarding the database you should be able to increase the lcr_id column <br>
in your installation.<br>
<br>
You might run into some limitations of the module if you increase the it <br>
too much, for example the module supports out of the box only 128 <br>
gateways. This can be increased with a config parameter.<br>
<br>
Keep in mind that the lcr module will loop e.g. for a DB reload over all <br>
lcr_id values. So in case you need to have large values or large gaps <br>
between the individual values you might want to look into another solution.<br>
<br>
Cheers,<br>
<br>
Henning<br>
<br>
Am 09.09.19 um 21:10 schrieb Grant Bagdasarian:<br>
> Hello,<br>
><br>
> The database tables definition for 5.2.x mentions the lcr_id parameter<br>
> being of unsigned short type, while in the code I only see definitions<br>
> of type int.<br>
><br>
> Is it safe to assume the parameter is of type int, so the database<br>
> column can also be set to an integer type?<br>
><br>
> Regards,<br>
><br>
> Grant<br>
><br>
> _______________________________________________<br>
> Kamailio (SER) - Users Mailing List<br>
> <a href="mailto:sr-users@lists.kamailio.org" target="_blank" moz-do-not-send="true">
sr-users@lists.kamailio.org</a><br>
> <a href="https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users" rel="noreferrer" target="_blank" moz-do-not-send="true">
https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users</a><br>
<br>
-- <br>
Henning Westerholt - <a href="https://skalatan.de/blog/" rel="noreferrer" target="_blank" moz-do-not-send="true">
https://skalatan.de/blog/</a><br>
Kamailio services - <a href="https://skalatan.de/services" rel="noreferrer" target="_blank" moz-do-not-send="true">
https://skalatan.de/services</a><br>
<br>
</blockquote>
</div>
</div>
</blockquote>
<pre class="moz-signature" cols="72">--
Henning Westerholt - <a class="moz-txt-link-freetext" href="https://skalatan.de/blog/">https://skalatan.de/blog/</a>
Kamailio services - <a class="moz-txt-link-freetext" href="https://skalatan.de/services">https://skalatan.de/services</a></pre>
</body>
</html>