<div dir="ltr"><div>Hey,</div>
<div>I didn't get any logs from the mysqld.</div>
<div>An option to disable this sorting will be great.</div>
<div>Thanks,</div>
<div>Uri</div>
<div><br><br> </div>
<div class="gmail_quote">On Sun, Feb 19, 2012 at 11:27 PM, Daniel-Constantin Mierla <span dir="ltr"><<a href="mailto:miconda@gmail.com">miconda@gmail.com</a>></span> wrote:<br>
<blockquote style="BORDER-LEFT:#ccc 1px solid;MARGIN:0px 0px 0px 0.8ex;PADDING-LEFT:1ex" class="gmail_quote">
<div bgcolor="#FFFFFF" text="#000000">Hello,
<div>
<div class="h5"><br><br>On 2/19/12 12:42 PM, Uri Shacked wrote:
<blockquote type="cite">
<div dir="ltr">
<div class="gmail_quote">
<blockquote style="BORDER-LEFT:rgb(204,204,204) 1px solid;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></div></div>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><span class="HOEnZb"><font color="#888888"><pre cols="72">
--
Daniel-Constantin Mierla -- <a href="http://www.asipto.com/" target="_blank">http://www.asipto.com</a>
<a href="http://linkedin.com/in/miconda" target="_blank">http://linkedin.com/in/miconda</a> -- <a href="http://twitter.com/miconda" target="_blank">http://twitter.com/miconda</a></pre></font></span></div></blockquote></div>
<br></div>