[bind10-dev] Blog comment from BDB developer

[Danny Mayer]

On 7/13/2010 8:51 AM, Elmar K. Bins wrote:
> </lurk>
> 
> Re guys,
> 
>>> BDB have one native flag ' DB_SET_RANGE ' supporting to get records in between. see the following discussions.
>>>
>> Yes I read that. The implications of this is that you are going to be
>> limiting bind10 to only use BDB since no other DB supports it. That's
>> okay if you are going to be making that as a final decision, but then
>> that needs to be explicitly stated.
> 
> In that case please make sure that BDB has no problem working with huge
> zones (>100 million rows), and at good performance.

When you get to very large tables performance depends very strongly on
properly tuned indexing. You can also get performance hits when the
table is badly fragmented and even the indexes becoming fragmented.

Performance can be improved sometimes by reviewing the database
architecture and moving some areas to additional tables but it is
heavily dependent on what is trying to be accomplished.

Danny