[SR-Users] Result limitation on sqlops

Daniel-Constantin Mierla miconda at gmail.com
Wed Oct 7 17:49:16 CEST 2020


And for the records: I just pushed the commit with code adding a
modparam for setting this value.

On 07.10.20 17:20, Daniel-Constantin Mierla wrote:
>
> Hello,
>
> that can be made a modparam, but do you really need more than 32
> result containers? The result containers can be reused if you do not
> need the results at the same time or to be persistent in the worker
> process. So even you do sql_query() more than 32 times, if you do not
> need all the 32+ results at the same time, then you should reuse the
> containers because it helps with performances (although it is not a
> real concern) as well as lower memory usage.
>
> In my configs, I do not recall any case when I needed more than 4,
> even on very intensive db-oriented configs (e.g., with more than 20
> queries on a request processing) and typically I have 1 or 2 result
> containers per config.
>
> Cheers,
> Daniel
>
> On 07.10.20 14:48, Duarte Rocha wrote:
>> Hey, 
>>
>> I just upgrade to Kamailio 5.4 and i see that now sqlops has a
>> limitation of 32 results containers which is not enough for my proxy.
>>
>> Is it possible that this limitation can be configured via module
>> parameters?
>>
>> In the meanwhile i've changed the value in sql_api.c but i would like
>> to have my source code as close as the original as possible.
>>
>> Best Regards,
>>
>> Duarte Rocha
>>
>> _______________________________________________
>> Kamailio (SER) - Users Mailing List
>> sr-users at lists.kamailio.org
>> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
> -- 
> Daniel-Constantin Mierla -- www.asipto.com
> www.twitter.com/miconda -- www.linkedin.com/in/miconda
> Funding: https://www.paypal.me/dcmierla

-- 
Daniel-Constantin Mierla -- www.asipto.com
www.twitter.com/miconda -- www.linkedin.com/in/miconda
Funding: https://www.paypal.me/dcmierla

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.kamailio.org/pipermail/sr-users/attachments/20201007/52980974/attachment.htm>


More information about the sr-users mailing list