[OpenSIPS-Users] Use of MemCache to Store Static Routing Info?

[Bogdan-Andrei Iancu]

Hello Will,

I think you have 2 options:

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)

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.

Regards,

Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
http://www.opensips-solutions.com

On 21.05.2014 23:09, Will Bazdarich wrote:
> Thanks in advance for looking,
> 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.
>
> 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?
>
> Thanks again!
> MW
>
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20140522/5f7642df/attachment.htm>