<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
Hello,<br>
<br>
On 2/19/12 12:42 PM, Uri Shacked wrote:
<blockquote
cite="mid:CAMMbDhQH_sd9PpPV4dPKtBWNMbtajBoxmXJYUU75z8neDHmRJA@mail.gmail.com"
type="cite">
<div dir="ltr">
<div class="gmail_quote">
<blockquote style="border-left: 1px solid rgb(204, 204, 204);
margin: 0px 0px 0px 0.8ex; padding-left: 1ex;"
class="gmail_quote">
<div dir="ltr">
<div>Hi,</div>
<div> </div>
<div>untill today i used the mtree module to get some data
from a remote DB and load it into memory.</div>
<div>the table in the data base has 5 million rows. prefix
is a number and value is some string.</div>
<div> </div>
<div>i moved to htable because i need the prefix exact
match and not longest....</div>
<div> </div>
<div>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.</div>
<div> </div>
<div>any ideas how to solve it?</div>
<div> </div>
</div>
</blockquote>
</div>
</div>
</blockquote>
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?<br>
<br>
Maybe an option to disable this sorting, for people not needing the
"array" functionality would be good to speed up a bit.<br>
<br>
Cheers,<br>
Daniel <br>
<pre class="moz-signature" cols="72">--
Daniel-Constantin Mierla -- <a class="moz-txt-link-freetext" href="http://www.asipto.com">http://www.asipto.com</a>
<a class="moz-txt-link-freetext" href="http://linkedin.com/in/miconda">http://linkedin.com/in/miconda</a> -- <a class="moz-txt-link-freetext" href="http://twitter.com/miconda">http://twitter.com/miconda</a></pre>
</body>
</html>