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

[Uri Shacked]

Hey,
I didn't get any logs from the mysqld.
An option to disable this sorting will be great.
Thanks,
Uri



On Sun, Feb 19, 2012 at 11:27 PM, Daniel-Constantin Mierla <
miconda at gmail.com> wrote:

> 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.comhttp://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/20120220/8d7b6f52/attachment.htm>