[sr-dev] usrloc and db only mode

Juha Heinanen jh at tutpro.com
Thu Feb 26 04:55:11 CET 2015


Victor Seva writes:

> > - for 2) -- add a new column 'keepalive' to be set internally by the
> > module to 1 if any of the flags for sending keepalive was set. Then the
> > query to fetch it will just use a match on it, rather that bitwise
> > operations in the match expression. Furthermore, this can be set to a
> > different value when enabling the keepalive partitioning (ie., sending
> > keepalives from different timer processes, each doing for a part of
> > natted users) - right now, for the db only mode, the selection is done
> > by column id % (number of keepalive processes).
> 
> really nice idea

yes, i once tested and there was no performance boost due to indexing
because of the bitiwise operation.

-- juha



More information about the sr-dev mailing list