[SR-Users] MySQL query result pagination

[Allen Zhang]

Not ideal because I have many TCP children. And each of them consumes private memory. 

-----Original Message-----
From: sr-users-bounces at lists.sip-router.org [mailto:sr-users-bounces at lists.sip-router.org] On Behalf Of Alex Balashov
Sent: Thursday, 5 June 2014 3:55 p.m.
To: sr-users at lists.sip-router.org
Subject: Re: [SR-Users] MySQL query result pagination

Allen,

Perhaps your best bet is simply to increase the amount of allocated private memory?

-- Alex

On 06/04/2014 08:18 PM, Allen Zhang wrote:

> Hi,
>
> When an user does a REGISTER and has a large number of msilo messages 
> stored, say 7k, kamailio server easily runs out of private memory when 
> trying to allocate memory to the result set. I know I can set a max on 
> the messages a user can store, but I'd like to support a crazy number 
> like 7k messages.
>
> I'm trying to introduce paging to the query. So that I can process N 
> number of results at one time.
>
> I can't find an easy way of doing this with the current MySQL driver.
> The *db_mysql_query**() *function doesn't have built-in paging and 
> with this function it's not easy to build a complex query like this:
>
> Select * from silo where ...(the matching algorithm) AND id > 
> lower_limit AND id < higher_limit, ordered by id.
>
> Is there a way to do this? Or maybe I'm on the wrong track and there 
> is already a solution to this problem?
>
> Regards,
>
> Allen Zhang
>
>
>
> _______________________________________________
> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing 
> list sr-users at lists.sip-router.org 
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>


--
Alex Balashov - Principal
Evariste Systems LLC
Tel: +1-678-954-0670
Web: http://www.evaristesys.com/, http://www.alexbalashov.com/

Please be kind to the English language:

http://www.entrepreneur.com/article/232906

_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users at lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users