[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Longhorn Killer

From: Raffael Herzog
Subject: Re: Longhorn Killer
Date: Tue, 23 Mar 2004 12:34:05 +0100
User-agent: Opera7.23/Linux M2 build 518

On Mon, 22 Mar 2004 16:57:32 -0800 (PST), Rogelio Serrano <address@hidden> wrote:

One of my basic problems is sorting and searching my emails. I have 10k plus in my mail folders already. Searching seems so slow and its difficult to search based on content. I think it goes for all my other files too. I tried writing all emails to individual files and using sym links but that was worse. It thrashed my hard disk like crazy.

I realize now that its really inefficient to use a database as a filesystem. Specially mysql or any other client server rdbms.

Well, now you're contradicting yourself. DB based systems can solve exactly the problems you're referring to in the first paragraph I quoted. As an example (and to get even more off-topic ;): Look at Opera's M2. I'm managing the mails of three IMAP and two NNTP accounts with this thing, there must be tens of thousands of messages, not a single one of them stored locally on my computer -- and believe it or not: I find the message I'm looking for within seconds. Why? Because M2 is a DB based system. Instead of using folders, it uses views to organise mail. You can look at them as SQL-Views, i.e. prepared SELECT statements on your mail/news -- on *all* of it, no matter where it's stored. Combined with quick access to several filters and a quick-search facility (incremental search on what's currently displayed), this is a very efficient system.

DBs are made for such tasks, the need for managing huge amounts of data and still quickly finding what you're looking for is actually the reason why they exist.


The difference between theory and practice is that in theory, there is no difference, but in practice, there is.

Raffael Herzog - address@hidden - www.raffael.ch - ICQ #67961355

reply via email to

[Prev in Thread] Current Thread [Next in Thread]