17 Sep
2012
17 Sep
'12
5:48 a.m.
Klaus Darilion writes:
I wonder why "expires" is checked at all?
Expired contacts will be
deleted automatically so the chance to ping expired contacts should be
very small.
klaus,
i wondered the same. it would not really hurt much if a small number of
expired contacts are binged for vain.
otherwise regarding the query, these two conditions
cflags & 0 = 0 and id % 20 = 0
are very inefficient, because an operation is applied to a field before
comparison. if nat flag would always be the largest flag, comparison
could go like this:
cflags >= "value of last flag"
and an index could be added on cflags.
-- juha