for sake of completion - it proved to be due to very long numbers inserted in the tree, resulting in lot of "unused" nodes comparing with the number of numbers stored.


On 9/28/10 3:22 PM, anthony thomas wrote:
Hello list,

I have been testing the new mtree module but I am a little bit confused about the results. 

On my tests, I randomly generated 500K, 1M and 2M entries in a table in several trees. The size of the db (on disk) ranges from 120 megs to 270 megs and when Kamailio loads it in memory, it jumps from 1.0Gb to 2.8Gb.

Is there any way to pre-calculate the total amount of memory that a tree will need?

Thanks,

A

-- 
Daniel-Constantin Mierla
http://www.asipto.com