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
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@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
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@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
Duarte,
It's hard to fathom a scenario in which you need anywhere near 32 result containers simultaneously. And if you don't need them simultaneously, they can be reused.
I have a very DB-intensive config with many, many queries and only need one container at any given time. I think I once had a scenario where I needed two -- it was a bizarre one.
-- Alex
On 10/7/20 8:48 AM, 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@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
-
Alex Balashov -
Daniel-Constantin Mierla -
Duarte Rocha