[EMAIL PROTECTED] wrote:
My question is: does the schema that comes with DBMail already have indexing defined in it or do I have to do my own indexing and optimization?
Yes, there are indexes - I just checked it with my db (the structure works, so it should not be too outdated). But especially the messages table seems to be over-indexed. That costs storage as well as insert/update performance. No problem with my little mail server, but at a larger scale it might cause trouble.
You should also think about installing a MySQL cluster and/or use MySQL Proxy. Caching will help a lot with read performance.
Michael _______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
