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
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
_______________________________________________
Users mailing list
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
