19 Feb
2012
19 Feb
'12
4:27 p.m.
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