[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