Hi all, I've landed another change as followup to the one from yesterday.
I've added an additional (hopefully last) caching table: dbmail_envelope, updated dbmail-util to fill the table, and fixed imap FETCH to use this table when appropriate. Outlook users can now also enjoy the greatly improved imap performance. All this means that opening a mailbox implies just a couple of queries, instead of a couple of queries per message! Dbmail just became that much easier on the backend, solving some of the scalability issues. so after updating and rebuilding: load the sql file in sql/*/2_1_7-2_1_8.sql, run dbmail-util -by restart, and fire away at those benchmarks. I've tested this on mysql and sqlite so far so some additional postgres confirmation is required. enjoy. -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl
