On Fri, 2004-10-29 at 15:19, Magnus Sundberg wrote: > What about placing all the headers in a RAM table type, dbmail > builds this table at startup. The content in this table should > only be something like > messageblock_id, header_name, header_value > I leave it to you to think out the inexing scheme. > This will make very fast header searches, and will be robust for > migration.
This is kind of a bad idea for dbmail, as then each of dbmail-pop3, dbmail-imap and a webmail implementation would have to allocate this memory each on it's own. And what if there are so many messages in the database that the server runs out of memory? Also there are complicated matters to take care of when making your own indexes. The proposed 2.1 feature of extracting the preparsed headers into a separate table in the database is a much more robust solution. It should give a significant speedup for imap and webmail atleast. -=Dead2=-
