2 Dec
2015
2 Dec
'15
1:22 p.m.
Hi All,
I need to run some SQL and then set the destination URI according to the
results, if any.
I've got this working using APP_LUA, however, I've noticed SQLOPS.
Can anyone advise on which method is likely to produce better results.
I'm assuming my Lua function is connecting to the DB and then disconnecting
each time.
If I use SQLOPS, does this mean Kamailio will keep a connection available
to the DB?
--
Luke Milbourne
<luke.milbourne(a)gmail.com>
Tel: 07857154817
Google Talk/Email: luke.milbourne(a)gmail.com
2 Dec
2 Dec
8:07 p.m.
On 12/02/2015 06:22 AM, Luke Milbourne wrote:
Hi All,
I need to run some SQL and then set the destination URI according to the
results, if any.
I've got this working using APP_LUA, however, I've noticed SQLOPS.
Can anyone advise on which method is likely to produce better results.
I'm assuming my Lua function is connecting to the DB and then
disconnecting each time.
If I use SQLOPS, does this mean Kamailio will keep a connection
available to the DB?
--
Luke Milbourne
<mailto:luke.milbourne@gmail.com>
Tel: 07857154817
Google Talk/Email: luke.milbourne(a)gmail.com
<mailto:luke.milbourne@gmail.com>
SQLOPS is a great tool and allows you to free when desired
(sql_result_free) as well as store the query results in xavps (or other
methods). You can run sql queries as well as call stored procedures.
You could easily run the query, store in xavp, free results and the use
the xavps later on (such as in failed route, etc).
Fred Posner
The Palner Group, Inc.
http://www.palner.com (web)
+1-224-334-3733 (direct)
3 Dec
3 Dec
3:55 p.m.
Hi Fred,
Thanks for your response.
Still getting to grips with Kamailio but so far so good.
Kind regards,
Luke
On 2 December 2015 at 18:07, Fred Posner <fred(a)palner.com> wrote:
On 12/02/2015 06:22 AM, Luke Milbourne wrote:
--
Luke Milbourne
<luke.milbourne(a)gmail.com>
Tel: 07857154817
Google Talk/Email: luke.milbourne(a)gmail.com
Hi All,
I need to run some SQL and then set the destination URI according to the
results, if any.
I've got this working using APP_LUA, however, I've noticed SQLOPS.
Can anyone advise on which method is likely to produce better results.
I'm assuming my Lua function is connecting to the DB and then
disconnecting each time.
If I use SQLOPS, does this mean Kamailio will keep a connection
available to the DB?
--
Luke Milbourne
<mailto:luke.milbourne@gmail.com>
Tel: 07857154817
Google Talk/Email: luke.milbourne(a)gmail.com
<mailto:luke.milbourne@gmail.com>
SQLOPS is a great tool and allows you to free when desired
(sql_result_free) as well as store the query results in xavps (or other
methods). You can run sql queries as well as call stored procedures.
You could easily run the query, store in xavp, free results and the use
the xavps later on (such as in failed route, etc).
Fred Posner
The Palner Group, Inc.
http://www.palner.com (web)
+1-224-334-3733 (direct)
_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
3280
days inactive
3281
days old
2 comments
2 participants
participants (2)
-
Fred Posner -
Luke Milbourne