Hello,

On 2/19/12 12:42 PM, Uri Shacked wrote:

Hi,

 

untill today i used the mtree module to get some data from a remote DB and load it into memory.

the table in the data base has 5 million rows. prefix is a number and value is some string.

 

i moved to htable because i need the prefix exact match and not longest....

 

now, after 5-10 sec, i get the following error (that i never got in mtree) - "lost connection to mysql during query" and kamailio does not start.

 

any ideas how to solve it?

 

iirc, htable does a sort with the query retrieving the data, in order to cope with "array" structures -- this may take a while in the mysql server, do you get any logs in the log file of mysql daemon?

Maybe an option to disable this sorting, for people not needing the "array" functionality would be good to speed up a bit.

Cheers,
Daniel

-- 
Daniel-Constantin Mierla -- http://www.asipto.com
http://linkedin.com/in/miconda -- http://twitter.com/miconda