cyrus imap + mysql as backend db ?

[Rob Siemborski]

On Tue, 4 Nov 2003, [ks_c_5601-1987] 원태환 wrote:

> I am considering to add mysql support as a backend of mboxlist DB.
> I have used skiplist and Berkeley DB so far.
> All of them have a serious contention problem.
> But, I want to know if it is a valuable work .

I'm not sure what you mean by "a serious contention problem."  Many sites
use skiplist quite successfully.

The access paterns against a cyrusdb don't map well to SQL -- in many
cases we enumerate the entire database (or a large portion of it), and
pull results at a higher level.  I suspect you'll see more performance
problems with a SQL backend (due to I/O) than you will with the memory
mapped skiplist database (or a properly tuned Berkeley DB)

-Rob


-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Rob Siemborski * Andrew Systems Group * Cyert Hall 207 * 412-268-7456
Research Systems Programmer * /usr/contributed Gatekeeper