Mailing List Archive: DBMail: users

One more word on database performance

Index | Next | Previous | View Threaded

lists.hzfw4 at liquidbytes

May 14, 2008, 4:32 AM

Post #1 of 4 (214 views)
Permalink

One more word on database performance

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
DBmail[at]dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail

aaron at serendipity

May 14, 2008, 5:06 AM

Post #2 of 4 (202 views)
Permalink

Re: One more word on database performance [In reply to]

On Wed, 2008-05-14 at 13:32 +0200, Michael Mayer wrote:

> But who could have such a large mailbox? Anyone here on this list? Then,
> you should think about creating an archive ;)

My Inbox has 36,881 messages right now. DBMail holds up quite well for
me. Personal stress test, eating my own dog food, etc. etc. :-)

Aaron

_______________________________________________
DBmail mailing list
DBmail[at]dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail

daniel at gosi

May 14, 2008, 5:14 AM

Post #3 of 4 (202 views)
Permalink

Re: One more word on database performance [In reply to]

>
> On Wed, 2008-05-14 at 13:32 +0200, Michael Mayer wrote:
>
>> But who could have such a large mailbox? Anyone here on this list?
>> Then,
>> you should think about creating an archive ;)
>
> My Inbox has 36,881 messages right now. DBMail holds up quite well for
> me. Personal stress test, eating my own dog food, etc. etc. :-)
>
> Aaron

Hmm, my inbox is quite big too. Aaron, which mail client do you use?
So far I find Thunderbird quite well working and I had quite a few
problems
with Microsoft Outlook ( not Express ).

greetings,
Daniel

aaron at serendipity

May 14, 2008, 10:48 PM

Post #4 of 4 (194 views)
Permalink

Re: One more word on database performance [In reply to]

On Wed, 2008-05-14 at 14:14 +0200, Daniel Urstöger wrote:
> >
> > On Wed, 2008-05-14 at 13:32 +0200, Michael Mayer wrote:
> >
> > > But who could have such a large mailbox? Anyone here on this list?
> > > Then,
> > > you should think about creating an archive ;)
> >
> > My Inbox has 36,881 messages right now. DBMail holds up quite well
> > for
> > me. Personal stress test, eating my own dog food, etc. etc. :-)
> >
> > Aaron
>
>
>
> Hmm, my inbox is quite big too. Aaron, which mail client do you use?
> So far I find Thunderbird quite well working and I had quite a few
> problems with Microsoft Outlook ( not Express ).

I use Evolution and Apple Mail on my desktops, and TWIG for webmail.

Aaron

_______________________________________________
DBmail mailing list
DBmail[at]dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail

Index | Next | Previous | View Threaded

Interested in having your list archived? Contact lists@gossamer-threads.com