Peter Evans wrote:

Dominic Marks (dom@goodforbusiness.co.uk) wrote:

Because you might, just possibly want performance that
doesn't resemble mollasses in midwinter?
Optionally, you might even want something where the response
time is deterministic.

Points at the company mail system here for a prime example
of why not to use mysql. But then again, this is actually
a prime example of "it works, but we don't know how."

P

We use mysql here as it makes a perfect integration with the rest of our systems, we have over 6000 mail accounts (probably closer to 7000 now) on it and the mysql lookup time is pretty much instant, the load never goes above 0.5 on the systems (2x1GHz Epias on round robin with replicated databases on each) and most of that is because the POP/IMAP servers are also round robin MX servers so Exim can take a chunk out of the CPU.

Regards Andrew

Andrew Hutchings (A-Wing) - Linux Guru Netserve Consultants - http://www.domaincity.co.uk/ A-Wing Internet Services - http://www.a-wing.co.uk/ Random quote 2: "In most countries selling harmful things like drugs is punishable. Then howcome people can sell Microsoft software and go unpunished?" - Hasse Skrifvars