Hi Paul and others! I've been very busy making a webmail interface directly into the dbmail database backend, and that has given me some time to gather some thoughts on the table layout.
For a typical email client there are to things that need to be optimized, which currently are quite slow: One is the messagecount (read messages and total) that are displayed for a dbmail_mailbox. Counting them everytime is quite a strain on the database. Secondly, the data retrieved for creating a message row with from address. subject, date. message size etc is scattered out along a few tables. The query needed for this pretty slow. as it contains a fair number of join's. What I'd like to have is a simple table per physmessage (or even _in_ dbmail_physmessage) containing the relevant information. Could using stored procedures be a solution to this problem? Grtz, Casper
_______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
