No subject

every 15 minutes (we expect this number will keep steadily increasing...)

As a side note, I've looked at how to implement the mt_match equivalent in
redis and it does't look that hard using kamailio s.prefixed transformation
(as you suggested) and redis sorted sets. I'll need to make more tests to
check the performance, I'll share the results.

Thanks!

Javi

>
> Cheers,
> Daniel
> >
> > Regards
> >
> > Javi
>

--20cf3079bfee71990404b1cc6786
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<div class=3D"gmail_quote"><blockquote class=3D"gmail_quote" style=3D"margi=
n:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">Hello<br><br>
coming back to the topic related to mtree, to be able to set values via<br>
mi/rpc -- it won&#39;t be that difficult to add such functionality. Usually=
<br>
with a tree is mainly reading, due to fast matching on tree indexing.<br>
The question is how many times/often do you need to change values and<br>
how many of them at the same time (more or less).<br>
<br></blockquote><div>I was also thinking about that: our application works=
 in such a way that the full tree is recalculated every 15 minutes. Current=
ly we have aound 60 branches with 150000 entries each.</div><blockquote cla=
ss=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;pa=
dding-left:1ex;">

I assume many times the changes will be somewhere down the tree, since<br>
the first part of the number is usually the same (e.g., country code and<br=
>
operator prefix). To update the tree at runtime, while there are reads<br>
on it, there must be used a lock to be safe an consistent. If you do lot<br=
>
of writes and very often, then you keep the tree structure locked a lot,<br=
>
slowing the search.<br></blockquote><div><br></div><div>That&#39;s the case=
, tname is rarely updated, it&#39;s tvalue the column that we normally upda=
te.</div><blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;borde=
r-left:1px #ccc solid;padding-left:1ex;">

<br>
Can you estimate the number of writes and how often they would be on a<br>
daily basis? There might be other solutions to look at, if writes are<br>
very often.<br></blockquote><div><br></div><div>From the numbers above, let=
&#39;s say that we need to update around 8M records every 15 minutes (we ex=
pect this number will keep steadily increasing...)</div><div><br></div>
<div>As a side note, I&#39;ve looked at how to implement the mt_match equiv=
alent in redis and it does&#39;t look that hard using kamailio s.prefixed t=
ransformation (as you suggested) and redis sorted sets. I&#39;ll need to ma=
ke more tests to check the performance, I&#39;ll share the results.</div>
<div><br></div><div>Thanks!</div><div><br></div><div>Javi=A0</div><blockquo=
te class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc so=
lid;padding-left:1ex;">
<br>
Cheers,<br>
Daniel<br>
&gt;<br>
&gt; Regards<br>
&gt;<br>
&gt; Javi<br></blockquote></div>

--20cf3079bfee71990404b1cc6786--