[SR-Users] LCR lcr_id short or int?

[Grant Bagdasarian]

Correct me if I’m wrong but isn’t a linear list slower than a tree
structure, due to the fact that it requires a full scan?

Also, how does querying the database for routing information fit in these
modules? It would require me to set the some kamailio routing variables
like $du/$ru myself right?

Thanks and regards,

Grant

On Tue, 10 Sep 2019 at 10:19, Henning Westerholt <hw at skalatan.de> wrote:

> Am 10.09.19 um 10:08 schrieb Henning Westerholt:
>
> Hello Grant,
>
> 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)
>
> somehow there is some content missing in the e-mail,
>
> In case of large route sets (like more than 10.000 up to a million
> entries) they can be queried faster as e.g. a linear list.
>
> 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.
>
> Cheers,
>
> Henning
> Am 10.09.19 um 09:59 schrieb Grant Bagdasarian:
>
> Hi Henning,
>
> Thanks for your reply.
> I figured the memory consumption and load times would increase as the
> tables grow.
>
> Are the carrierroute and drouting modules more efficient when it comes
> down to memory consumption and load times?
>
> Regards,
>
> Grant
>
> On Mon, 9 Sep 2019 at 21:46, Henning Westerholt <hw at skalatan.de> wrote:
>
>> Hello Grant,
>>
>> regarding the database you should be able to increase the lcr_id column
>> in your installation.
>>
>> You might run into some limitations of the module if you increase the it
>> too much, for example the module supports out of the box only 128
>> gateways. This can be increased with a config parameter.
>>
>> Keep in mind that the lcr module will loop e.g. for a DB reload over all
>> lcr_id values. So in case you need to have large values or large gaps
>> between the individual values you might want to look into another
>> solution.
>>
>> Cheers,
>>
>> Henning
>>
>> Am 09.09.19 um 21:10 schrieb Grant Bagdasarian:
>> > Hello,
>> >
>> > The database tables definition for 5.2.x mentions the lcr_id parameter
>> > being of unsigned short type, while in the code I only see definitions
>> > of type int.
>> >
>> > Is it safe to assume the parameter is of type int, so the database
>> > column can also be set to an integer type?
>> >
>> > Regards,
>> >
>> > Grant
>> >
>> > _______________________________________________
>> > Kamailio (SER) - Users Mailing List
>> > sr-users at lists.kamailio.org
>> > https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
>>
>> --
>> Henning Westerholt - https://skalatan.de/blog/
>> Kamailio services - https://skalatan.de/services
>>
>> --
> Henning Westerholt - https://skalatan.de/blog/
> Kamailio services - https://skalatan.de/services
>
>
> _______________________________________________
> Kamailio (SER) - Users Mailing Listsr-users at lists.kamailio.orghttps://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
>
> --
> Henning Westerholt - https://skalatan.de/blog/
> Kamailio services - https://skalatan.de/services
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.kamailio.org/pipermail/sr-users/attachments/20190910/e01105fe/attachment.html>