<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=utf-8">
<meta name=Generator content="Microsoft Word 15 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
pre
{mso-style-priority:99;
mso-style-link:"HTML Preformatted Char";
margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";}
p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:Consolas;}
span.EmailStyle21
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:#595959;}
span.EmailStyle22
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:#595959;}
span.EmailStyle23
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:#595959;}
span.EmailStyle24
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:#595959;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span style='color:#595959'>How did I missed that </span><span style='font-family:"Segoe UI Emoji",sans-serif;color:#595959'>😊</span><span style='color:#595959'><o:p></o:p></span></p><p class=MsoNormal><span style='color:#595959'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#595959'>Thank you Vlad<o:p></o:p></span></p><p class=MsoNormal><span style='color:#595959'><o:p> </o:p></span></p><div><p class=MsoNormal style='mso-margin-top-alt:0cm;margin-right:0cm;margin-bottom:9.0pt;margin-left:1.0pt;line-height:16.5pt'><b><span style='color:#5F5F5F'>Antonis Psaras</span></b><span lang=EL style='color:#595959'><o:p></o:p></span></p></div><p class=MsoNormal><span style='color:#595959'><o:p> </o:p></span></p><div><div style='border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=MsoNormal><b>From:</b> Vlad Paiu <vladpaiu@opensips.org> <br><b>Sent:</b> Δευτέρα, 17 Οκτωβρίου 2022 10:55<br><b>To:</b> apsaras@microbase.gr; OpenSIPS users mailling list <users@lists.opensips.org><br><b>Subject:</b> Re: [OpenSIPS-Users] Load a DB Table to hash with MI control<o:p></o:p></p></div></div><p class=MsoNormal><o:p> </o:p></p><p>Hello,<o:p></o:p></p><p>Check out the sql_cacher [1] module.<o:p></o:p></p><p>[1] <a href="https://opensips.org/html/docs/modules/2.4.x/sql_cacher.html">https://opensips.org/html/docs/modules/2.4.x/sql_cacher.html</a><o:p></o:p></p><p class=MsoNormal><br>Regards,<br>Vlad<o:p></o:p></p><div><p class=MsoNormal>On 17.10.2022 10:36, Antonis Psaras wrote:<o:p></o:p></p></div><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><p class=MsoNormal><span style='color:#595959'>Dear all</span><o:p></o:p></p><p class=MsoNormal><span style='color:#595959'> </span><o:p></o:p></p><p class=MsoNormal><span style='color:#595959'>I am looking to implement a functionality similar to htable module were I will have a db table with some key values which will be loaded during service start and will expire every x sec or forced to be reloaded by MI. Using OpenSIPs 2.4</span><o:p></o:p></p><p class=MsoNormal><span style='color:#595959'> </span><o:p></o:p></p><p class=MsoNormal><span style='color:#595959'>Any suggestion?</span><o:p></o:p></p><p class=MsoNormal><span style='color:#595959'> </span><o:p></o:p></p><p class=MsoNormal><span style='color:#595959'>Best regards</span><o:p></o:p></p><p class=MsoNormal><span style='color:#595959'> </span><o:p></o:p></p><div><p class=MsoNormal style='mso-margin-top-alt:0cm;margin-right:0cm;margin-bottom:9.0pt;margin-left:1.0pt;line-height:16.5pt'><b><span style='color:#5F5F5F'>Antonis Psaras</span></b><o:p></o:p></p></div><p class=MsoNormal><br><br><o:p></o:p></p><pre>_______________________________________________<o:p></o:p></pre><pre>Users mailing list<o:p></o:p></pre><pre><a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><o:p></o:p></pre><pre><a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><o:p></o:p></pre></blockquote></div></body></html>