[SR-Users] SQLOps question

[Maciej Bylica]

>>> 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.
>
First of all, thanks for reply.

Henning, yes AVP could store the query result -- works fine, thank You.
In meantime I reconstructed my script to use LCR instead of SQLOps for
calling number routing, but experience I gained here is v. useful :)

Cheers,
Maciej.