Re: LIST is slow for 35K mailboxes

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

 



Ian G Batten <ian.batten@xxxxxxxxxxxxxx> wrote:

>
> On 09 Oct 07, at 1522, Blake Hudson wrote:
>>>
>> Could database type differences (or contention) be an issue here? What
>> database format are each of you using?
>
> Yes.  With skiplist (took me several stabs at it to get the
> conversion to work) it takes 0.19s.  Versus ~250s with BDB.  A slight
> difference.  Thanks for pointing me at the idea.

Yes, this is the expected result. Skiplist is good in enumerating as there 
is always a "lane" pointing from one mailbox to the next one without 
skipping.

Berkeley DB is very fast in doing _real_ random accesses and to insert new 
or changed values, but it does a lousy lob in enumerating "entries" 
alphabetically or numerically. So it is perfect to use Berkeley for the tls 
session database, for annotations, for duplicate delivery suppression and - 
as Bron Gondwana does - to cache status data.

Pascal
----
Cyrus Home Page: http://cyrusimap.web.cmu.edu/
Cyrus Wiki/FAQ: http://cyrusimap.web.cmu.edu/twiki
List Archives/Info: http://asg.web.cmu.edu/cyrus/mailing-list.html

[Index of Archives]     [Cyrus SASL]     [Squirrel Mail]     [Asterisk PBX]     [Video For Linux]     [Photo]     [Yosemite News]     [gtk]     [KDE]     [Gimp on Windows]     [Steve's Art]

  Powered by Linux