[SR-Users] Result limitation on sqlops

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


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

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


More information about the sr-users mailing list