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,

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

[SR-Users] Can't connect to db

2019-09-10 Thread Andrew Chen
Hi all, I just installed kamailio 5.2.4 on two separate aws instances in two separate regions. Both regions uses the same configuration template and share the same db in AWS RDS. The issue I see is this: - SJO location was able to launch fine without any issues. - ASH location could not start up

Re: [SR-Users] Can't connect to db

2019-09-10 Thread Andrew Chen
Sorry..ignore this. Found the issue. The max connection setting on the RDS was too low. Thanks On Tue, Sep 10, 2019 at 5:43 PM Andrew Chen wrote: > Hi all, > I just installed kamailio 5.2.4 on two separate aws instances in two > separate regions. Both regions uses the same configuration

Re: [SR-Users] Can't connect to db

2019-09-10 Thread Fred Posner
On 9/10/19 5:43 PM, Andrew Chen wrote: > Hi all, > ... > Sep 10 21:24:13 ashmainkama51 /usr/sbin/kamailio[8043]: ERROR: db_mysql > [km_my_con.c:139]: db_mysql_new_connection(): driver error: Too many > connections > Looks like you have a connections setting issue on the DB... try increasing it.

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

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

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
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