23 Aug
2017
23 Aug
'17
10:21 a.m.
On Tue, Aug 22, 2017 at 04:28:35PM +0200, Nelson Migliaro wrote:
I am using the uac_replace_from function but I would
like to pull the
caller id from a database to set up the number based on the sip vendor the
call is forwarded
What would be the correct way to do that?
I was thinking of:
sql_query("ca", "select ddi from ddi_table where xxx= $rU limit 1",
"ra");
$avp(dnis) = $dbr(ra=>[0,0]);
sql_result_free("ra");
Don't get what you are trying to do here, you are looking at the called
"number" ($rU) to find a callerID for the caller!
But I am afraid of causing a bottheneck on the
database.
Sure a database lookup would be the slowest/most time consuming part of
handling the transaction, but you'd have to handle lots of calls before
it will be the actual bottleneck. You could populate a $sht() variable
( http://kamailio.org/docs/modules/stable/modules/htable.html )
instead to keep this data in memory, or use an external key/value memory
database like redis.