Re: [SR-Users] mtree on db Berkeley DB?

Hello, On 11/12/11 1:28 PM, Javier Gallart wrote: ok, in the same idea of a remote caching system, we have memcache connector module, but probably it is the same situation as with redis. Back to initial topic, I am not a user of db_berkeley, but afaik, the module loads the content in memory of kamailio, so if you use mtree, then it is practically a duplicate of content. Besides, I guess db_berkeley will have some internal structure overhead that will use a bit more memory. What I can think of at this moment for a solution will be adding/removing prefixes from mtree using mi/rpc command, so in case of change of records, instead of loading the database table, the updates can be done from command line or so. Another option might be using database directly. With mysql, a good solution is to define database table in memory, then add/updates records there as needed. From config file, use sqlops with sql_query, matching using 'IN' operator, against matching number exapnded with s.prefixes transformation: http://www.kamailio.org/wiki/cookbooks/3.2.x/transformations#sprefixes_len Also, afaik, if you want postgres, it has some sort of index plugin that can be used to match on longest prefix. Cheers, Daniel -- Daniel-Constantin Mierla -- http://www.asipto.com Kamailio Advanced Training, Dec 5-8, Berlin: http://asipto.com/u/kat http://linkedin.com/in/miconda -- http://twitter.com/miconda