<p dir="ltr">Why don't u use avp_db_query on demand and cache the info so u don't need to run this particular query again?</p>
<div class="gmail_quote">On Feb 19, 2016 4:47 PM, "John Quick" <<a href="mailto:john.quick@smartvox.co.uk">john.quick@smartvox.co.uk</a>> wrote:<br type="attribution"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Using version 2.1.1 of OpenSIPS<br>
I want to load several hundred records into local cache memory on startup.<br>
I've tried avp_db_query to read all data into an avp, then a loop to write<br>
it from the avp into cache memory, but it can only do 100 records at a time.<br>
Is this simply a limitation of all avp's?<br>
<br>
Is there another way, a better way?<br>
<br>
Why do I want to do this? Because I want to check each INVITE ruri<br>
destination username against a list of known "suspicious" destination<br>
prefixes (perhaps 1000 records). Each call may require several checks<br>
because the list contains prefixes of varying lengths. I am concerned that<br>
queries made directly to the MySQL table as each INVITE request is received<br>
could impair performance and would put constant unwanted load on the MySQL<br>
server.<br>
<br>
John Quick<br>
Smartvox Limited<br>
Web: <a href="http://www.smartvox.co.uk" rel="noreferrer" target="_blank">www.smartvox.co.uk</a><br>
<br>
<br>
<br>
_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" rel="noreferrer" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
</blockquote></div>