Closed Bug 58775 Opened 25 years ago Closed 17 years ago

remove empty threads from db when last msg header is deleted to improve performance

Categories

(MailNews Core :: Database, defect, P2)

Product:
MailNews Core
Component:
Database
Type:
defect

Tracking

(Not tracked)

Status:
RESOLVED FIXED
Milestone:
Future

People

(Reporter: Bienvenu, Assigned: Bienvenu)

References

(Blocks 1 open bug)

Details

(Keywords: perf, Whiteboard: [nsbeta1+ 2/13])

When we delete the last header from a thread, we should delete the thread table from the underlying MDB database.
this will improve performance by making databases smaller, and reducing the memory footprint of an open database.
Status: NEW → ASSIGNED
Keywords: perf
Keywords: mail1
changing priorities
Priority: P3 → P2
masrking nsbeta1+ and moving to mozilla0.8
Keywords: nsbeta1
Whiteboard: [nsbeta1+]
Target Milestone: --- → mozilla0.8
moving to mozilla0.9
Target Milestone: mozilla0.8 → mozilla0.9
marking nsbeta1- and moving to future milestone.
Keywords: nsbeta1 → nsbeta1-
Whiteboard: [nsbeta1+] → [nsbeta1+ 2/13]
Target Milestone: mozilla0.9 → Future
Blocks: 236849
Product: MailNews → Core
this still true?
Status: ASSIGNED → NEW
OS: Windows NT → All
QA Contact: esther → database
Hardware: PC → All
Summary: remove empty threads from db when last msg header is deleted → remove empty threads from db when last msg header is deleted to improve performance
I don't know if this is still true. My recollection is that Mork is supposed to do this for us (delete empty tables with no references to them) and it may do so.
This may not be true, based on my 16913 tests. I'll have to look into it more....
I can't quite tell if mork does this or not (there is a lot of code marked "to be fixed later" or similar in mork). But you actually fixed this back in 2002 as a result of bug 140613...
Status: NEW → RESOLVED
Closed: 17 years ago
Resolution: --- → FIXED
Product: Core → MailNews Core
You need to log in before you can comment on or make changes to this bug.