Thanks Henning for the assistance! On Tue, Sep 10, 2019 at 11:28 AM Henning Westerholt <[email protected]> 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 be also faster as a database query. Some > details about the datastructures: carrierroute uses a trie, drouting a prefix > tree (not looked deeply into drouting). > > In case of using a database directly, yes you will need to set the > appropriate pseudo-variables by yourself. > > Cheers, > > Henning > > Am 10.09.19 um 10:43 schrieb 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 <[email protected]> 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 <[email protected]> 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 >>> > [email protected] >>> > 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 List >> [email protected] >> 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 List [email protected] https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
