Re: [SR-Users] LCR lcr_id short or int?

2019-09-10 Thread Grant Bagdasarian
Thanks Henning for the assistance! On Tue, Sep 10, 2019 at 11:28 AM Henning Westerholt wrote: > > Hello Grant, > > yes, traversing a linear list is of course slower as a tree structure. This > is one major advantage of using this modules. As the modules query a > in-memory structure, they will

Re: [SR-Users] LCR lcr_id short or int?

2019-09-10 Thread Henning Westerholt
Hello Grant, yes, traversing a linear list is of course slower as a tree structure. This is one major advantage of using this modules. As the modules query a in-memory structure, they will be also faster as a database query. Some details about the datastructures: carrierroute uses a trie, drout

Re: [SR-Users] LCR lcr_id short or int?

2019-09-10 Thread 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?

Re: [SR-Users] LCR lcr_id short or int?

2019-09-10 Thread Henning Westerholt
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 ca

Re: [SR-Users] LCR lcr_id short or int?

2019-09-10 Thread 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). But depending on your scenario (and the other queries that you already do in the cfg) you maybe also might

Re: [SR-Users] LCR lcr_id short or int?

2019-09-10 Thread 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

Re: [SR-Users] LCR lcr_id short or int?

2019-09-09 Thread Henning Westerholt
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 pa