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

[Uri Shacked]

>
>  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?
>
> cheers,
>
> Uri
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20120219/d9a42e94/attachment.htm>