A BUGNOTE has been added to this bug. ====================================================================== http://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: 15-Sep-04 19:59 CEST ====================================================================== 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. 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 ======================================================================