[SR-Users] SQLOPS vs APP_LUA

[Luke Milbourne]

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 at palner.com> wrote:

> 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 at gmail.com>
> >
> > Tel: 07857154817
> > Google Talk/Email: luke.milbourne at gmail.com
> > <mailto:luke.milbourne at 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 at lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>
>


-- 
Luke Milbourne
<luke.milbourne at gmail.com>

Tel: 07857154817
Google Talk/Email: luke.milbourne at gmail.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20151203/bb1c2ef9/attachment.html>