Hi there,
one more word on database performance: If you got an index on the
mailbox id and the data is even clustered, then most of the other
indexes like seen_flag_index would render useless, if sorting and
filtering is mainly limited to one particular database.
Any current server machine can do such tasks in no-time (please prove me
wrong):
- Remember that the average row size is 130 Byte!
- 8000 rows fit in 1 MB and 125 messages fit in one single 16K data page.
- That's a joke, as even the processor cache of a Core 2 duo or Xeon is
much larger!
- Don't ever access the hard disk for such an amount of data. It's
nothing. Peanuts.
Indexes are useful, if the data to be searched or sorted does NOT fit in
memory. Maybe if you want to build a Web search like Google.
But who could have such a large mailbox? Anyone here on this list? Then,
you should think about creating an archive ;)
Michael
_______________________________________________
DBmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
