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?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?
-- Daniel-Constantin Mierla -- http://www.asipto.com http://linkedin.com/in/miconda -- http://twitter.com/miconda