[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: When does a table outperform a list?

> In my ruleset, I've only defined a table for a huge list of IP addresses 
> belonging to adservers. I've no doubt that a table will perform better 
> than a list in this case.
> But when does a table begin to outperform a list? I imagine a list is 
> quicker when the list contains two or three items, but at what point 
> would it be more efficient to put the items into a table?
IIRC Daniel did tests about two years ago and the break-even point was
about 6 addresses. That is what the optimizer uses to merge similar
rules into a single rule with a table.