From mboxrd@z Thu Jan 1 00:00:00 1970 X-Msuck: nntp://news.gmane.io/gmane.emacs.gnus.general/42450 Path: main.gmane.org!not-for-mail From: Lars Magne Ingebrigtsen Newsgroups: gmane.emacs.gnus.general Subject: Re: db-backed mail back end Date: Wed, 23 Jan 2002 01:36:19 +0100 Organization: Programmerer Ingebrigtsen Sender: owner-ding@hpc.uh.edu Message-ID: References: <87g04x7w4q.fsf@inanna.rimspace.net> NNTP-Posting-Host: coloc-standby.netfonds.no Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Trace: main.gmane.org 1035177685 11442 80.91.224.250 (21 Oct 2002 05:21:25 GMT) X-Complaints-To: usenet@main.gmane.org NNTP-Posting-Date: Mon, 21 Oct 2002 05:21:25 +0000 (UTC) Return-Path: Original-Received: (qmail 2542 invoked from network); 23 Jan 2002 00:37:21 -0000 Original-Received: from malifon.math.uh.edu (mail@129.7.128.13) by mastaler.com with SMTP; 23 Jan 2002 00:37:21 -0000 Original-Received: from sina.hpc.uh.edu ([129.7.128.10] ident=lists) by malifon.math.uh.edu with esmtp (Exim 3.20 #1) id 16TBP9-0000sw-00; Tue, 22 Jan 2002 18:36:43 -0600 Original-Received: by sina.hpc.uh.edu (TLB v0.09a (1.20 tibbs 1996/10/09 22:03:07)); Tue, 22 Jan 2002 18:36:38 -0600 (CST) Original-Received: from sclp3.sclp.com (qmailr@sclp3.sclp.com [209.196.61.66]) by sina.hpc.uh.edu (8.9.3/8.9.3) with SMTP id SAA07141 for ; Tue, 22 Jan 2002 18:36:26 -0600 (CST) Original-Received: (qmail 2533 invoked by alias); 23 Jan 2002 00:36:26 -0000 Original-Received: (qmail 2528 invoked from network); 23 Jan 2002 00:36:26 -0000 Original-Received: from ingebrigtsen.no (HELO quimby2.netfonds.no) (195.204.10.66) by gnus.org with SMTP; 23 Jan 2002 00:36:26 -0000 Original-Received: from news by quimby2.netfonds.no with local (Exim 3.12 #1 (Debian)) id 16TBPf-0004R1-00 for ; Wed, 23 Jan 2002 01:37:15 +0100 Original-To: ding@gnus.org Original-Path: not-for-mail Original-Newsgroups: gnus.ding Original-Lines: 26 Original-NNTP-Posting-Host: quimbies.gnus.org Original-X-Trace: quimby2.netfonds.no 1011746235 13832 195.204.10.148 (23 Jan 2002 00:37:15 GMT) Original-X-Complaints-To: usenet@quimby2.netfonds.no Original-NNTP-Posting-Date: 23 Jan 2002 00:37:15 GMT Mail-Copies-To: never X-Now-Playing: Various's _Knowing We Was Right From The Start_: "Kid606 - Dodgy" User-Agent: Gnus/5.090006 (Oort Gnus v0.06) Emacs/21.1 (i686-pc-linux-gnu) X-Face: 'M%H/,jh0#&`N@sYsVA[nDVTahS,9&]f@kwvZa!):4]/GuQ%{,>33j}?=&GcK\x7#:N>t55 {a.~fn#8WUz/P2nsMd_*II:j#`4{UmNVO'43fA:_H"6/sNz|!NyOjiIMxTWT/,lF@C{=6Ff$ Cancel-Lock: sha1:kdxLNuSAs0HUgXiXmvNhna6nU2A= Precedence: list X-Majordomo: 1.94.jlt7 Xref: main.gmane.org gmane.emacs.gnus.general:42450 X-Report-Spam: http://spam.gmane.org/gmane.emacs.gnus.general:42450 Daniel Pittman writes: > Gain? For me, the biggest pain with Gnus right now is that there are > some scalability issues. I got sick of losing information that had been > on mailing lists, so I stopped expiring mail a couple of years ago. A db doesn't necessarily give you any performance gain. If you're not careful with how you set things up, you can get arbitrarily awful db performance (and I should know, since I've been Oracling a lot these past years. :-)) > Disk space is sufficiently cheap, even for a laptop, that I don't have > space issues with this. Gnus starts to feel a little pain, sometimes, > though when dealing with groups in the > 75,000 messages range (with > NNML.) Perhaps the question should be restated as such: If we were to design a mail back end that's supposed to scale to several hundred thousands of messages in thousands of groups -- how would we do that? Perhaps somebody has pondered this question before. :-) -- (domestic pets only, the antidote for overdose, milk.) larsi@gnus.org * Lars Magne Ingebrigtsen