[SR-Users] Mtree VS Htable getting huge amount of data from DB not on local machine

[Daniel-Constantin Mierla]

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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20120219/3fbc918e/attachment-0001.htm>