On 04/18/2010 01:21 PM, Maciej Bylica wrote:
Hello,
I am trying to use SQLOps Module in my kamailio 1.5 configuration.
According to your explanations every result of sql_query should be
freed just after using that data.
So it means that there will be better to fetch for THE SAME data three
times instead of just one.
Am I right?
But nevertheless I've been trying to query just one and free the
result of the sql_query at the end of the file.
Could sb tell me if the result of sql query executed in the main part
of the script is remembered and could be used on failure route as
well?
As far as I know, sqlops results are freed at the end of invocation of
script processing of a given message, be that a request or a reply.
They do not persist for the life of the transaction, and therefore
cannot be reused in failure_route.
the sqlops query is freed either by the
sql_result_free() or by another
sql_query() that stores over the same result id. So you can use the same
result for many sip messages, but withing the same process, the result
uses private memory.
Cheers,
Daniel
--
Daniel-Constantin Mierla *