why an SQL Database?

Derek Broughton news at pointerstop.ca
Mon Nov 26 15:23:35 UTC 2007

Caleb Marcus wrote:

> On Sat, 2007-11-24 at 19:06 -0700, Scott (angrykeyboarder) wrote:
>> is would work with IMAP?  I switched to IMAP from POP
>>  a year ago and I've learned that IMAP (while better for my needs) isn't
>> quite what I thought it was gonna be (it's slow and search is *beyond*
>> slow - compared to POP).
> IMAP's advantage is also its greatest disadvantage... since all the mail
> resides on the server, searching through undownloaded headers takes a
> long time as the client has to download every message in order to search
> it. 

iirc (and it's a long time since I looked into this) that's not
hard-and-fast.  IMAP has the ability to do that searching on the server, so
using a dbmail backend with Postgre, full-text searching, and IMAP to
present the data to KMail or other MUA should be possible.  It _may_
require mods to the MUA to make it send the correct IMAP commands.

More information about the ubuntu-users mailing list