A BUGNOTE has been added to this bug. ====================================================================== http://www.dbmail.org/mantis/bug_view_advanced_page.php?bug_id=0000007 ====================================================================== Reported By: Dead2 Assigned To: ====================================================================== Project: DBMail Bug ID: 7 Category: General Reproducibility: always Severity: feature Priority: normal Status: acknowledged ====================================================================== Date Submitted: 09-Jul-04 12:42 CEST Last Modified: 08-Nov-04 18:05 CET ====================================================================== Summary: Separate Headers table Description: The headers should be put in a a separate table to facilitate faster searching and better logic
This would remove the 'messageblk->is_header'. It would then add a table containing only the headers. Positive sides: -Smaller index to search when getting header info -Better separation leading to good logic -Makes it possible to have different storage policies for header and messagebody Negative sides: -Not backwards compatible ====================================================================== ---------------------------------------------------------------------- ilja - 09-Jul-04 14:45 CEST ---------------------------------------------------------------------- This might be interesting. I don't know what the consquences might be. We should discuss this on dbmail-dev. ---------------------------------------------------------------------- ljackson - 15-Sep-04 19:59 CEST ---------------------------------------------------------------------- I belive that this would not give us any more performance, time should be focused on header caching that will give the most improment to a lot of things and let me finish my sorting code and write a really kicking THREAD implementation. ---------------------------------------------------------------------- jnorell - 08-Nov-04 18:05 CET ---------------------------------------------------------------------- Looks like there is no ticket open to track header (or rather, message data) caching ... maybe there was a discussion on the old dbmail wiki. Also see https://sourceforge.net/tracker/index.php?func=detail&aid=786484&group_id=85894&atid=577645 Bug History Date Modified Username Field Change ====================================================================== 09-Jul-04 12:42Dead2 New Bug 09-Jul-04 14:45ilja Bugnote Added: 0000011 09-Jul-04 14:45ilja Status new => acknowledged 15-Sep-04 19:59ljackson Bugnote Added: 0000259 08-Nov-04 18:05jnorell Bugnote Added: 0000348 ======================================================================