<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix"><tt>Hello Will,<br>
<br>
I think you have 2 options:<br>
<br>
1) better use a no-SQL db for storing your data, a no-SQL that
can run in-cache only (memcached or mongoDB can do it for sure)<br>
<br>
2) if you want to use memcache (opensips internal cache), you
need to populate it - you can do this at startup , via the
startup route -> load from SQL DB into memcache.<br>
<br>
Regards,<br>
</tt>
<pre class="moz-signature" cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a class="moz-txt-link-freetext" href="http://www.opensips-solutions.com">http://www.opensips-solutions.com</a></pre>
On 21.05.2014 23:09, Will Bazdarich wrote:<br>
</div>
<blockquote
cite="mid:1400702952.25340.YahooMailNeo@web140204.mail.bf1.yahoo.com"
type="cite">
<div style="color:#000; background-color:#fff;
font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial,
Lucida Grande, sans-serif;font-size:10pt">Thanks in advance for
looking,
<div>I have a simple set up here in NorAM that does LNP look ups
as well as some simple routing logic based on the Originating
and Terminating state from the LERG database. I have been
thinking that it is overkill and more resource intensive than
necessary to store the LERG in MySQL when we update it only
once a quarter. I understand that MySQL does it's own caching
which can be very fast but I'm hoping I can save 2 MySQL
queries per call by storing the data in MemCache instead.</div>
<div><br>
</div>
<div>Cut to the chase: is it possible to store data from a file
into a MemCache store when the script starts up? Is there
another method that is more appropriate for this task that I
am ignorant of?</div>
<div><br>
</div>
<div>Thanks again!</div>
<div>MW</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<a class="moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
<br>
</body>
</html>