26 Feb
2015
26 Feb
'15
3:55 a.m.
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