RE: [Dbmail] trackrecord + (Scalability REPOST)

2003-12-04 Thread Mark Mackay - Orcon
> - you need a clusterable database (For 2.0 you should be able > to write a oracle driver in about 4 hours). >(real clustered databases partition automatically). Heard scary things about Oracle from an admin point-of-view, but expect unfortuantely I'll need to look at that in the future. Fig

[Dbmail] 2.0 and header-cache

2003-12-04 Thread Mark Mackay - Orcon
Hi guys - Another quick question (first time I've really looked at 2.0 other than listening to the list). Is 2.0 going to have any type of header cache (something that's suited to the native-webmail clients everyone's no-doubt hacking away at? We implemented some patches to 1.x and posted them

Re: [Dbmail] 2.0 and header-cache

2003-12-04 Thread Ricardo Andere de Mello
Em Quarta 03 Dezembro 2003 20:27, Mark Mackay - Orcon escreveu: > Is 2.0 going to have any type of header cache (something that's suited to > the native-webmail clients everyone's no-doubt hacking away at? We > implemented some patches to 1.x and posted them to a list a while back > which cached

RE: [Dbmail] 2.0 and header-cache

2003-12-04 Thread Mark Mackay - Orcon
The separated fields are really useful as it means you can show a message listing using a simple join in SQL. Just having the headers flagged or in a separate msgblk means you need to process and interate every visible message, every time you show a mail listing -- very innefficient, unless you use

Re: [Dbmail] trackrecord

2003-12-04 Thread
first installation: 1 MySQL 4.0.13 database 2 pop/smtp servers postfix + dbmail 1.1 (CVS) 26K users, 15 GB maildata second installation: 1 MySQL 4 database + IMAP/POP postfix + dbmail 1.0rc4 (POP), 1.1 CVS (IMAP) 600 users, 5 GB maildata Op 3-dec-03 om 16:47 heeft Eelco van Beek - IC&S het

Re: [Dbmail] trackrecord + (Scalability REPOST)

2003-12-04 Thread
Heard scary things about Oracle from an admin point-of-view, but expect unfortuantely I'll need to look at that in the future. Figured it would be relatively trivial to do (write driver).. Keep hoping MySQL will have two-way replication soon with write locks and then it's all solved :o) Just do

RE: [Dbmail] trackrecord + (Scalability REPOST)

2003-12-04 Thread Chris Carter
> Well, Aaron has been working on an LMTP daemon, it is in his > big patch. Since i forgot about that i've been working on one > also and that one is > sitting > here on my laptop :) I've done some testing and in stead of 4 - 8 > messages (dbmail-smtp) > per second it can do over 300 messages p

Re: [Dbmail] 2.0 and header-cache

2003-12-04 Thread Magnus Sundberg
One silly question, How do we know which headers to cache? The headers are stored in the first messageblock in for the message. Suppose we stored the headers in a separate table and used the database indexing facilities. We could then do without a separate header cache, by just using well form

RE: [Dbmail] 2.0 and header-cache

2003-12-04 Thread Mark Mackay - Orcon
> One silly question, > How do we know which headers to cache? Ideally it would be customisable (even if needed to Define things at compile time, etc). Most people are after the header-cache-like-thing for webmail clients, or management reports/etc -- thus the ones I had below were the ones that c

Re: [Dbmail] 2.0 and header-cache

2003-12-04 Thread Ricardo Andere de Mello
Em Quinta 04 Dezembro 2003 07:49, Magnus Sundberg escreveu: > One silly question, > How do we know which headers to cache? > The headers are stored in the first messageblock in for the message. > Suppose we stored the headers in a separate table and used the > database indexing facilities. > We cou

[Dbmail] message size during move

2003-12-04 Thread Ricardo Andere de Mello
err... I moved some messages from one folder to a dmail account using kmail, and then messages showed the size of 0 bytes. looking at the code I found this at mysql/mysql.c: snprintf(query, DEF_QUERYSIZE, "INSERT INTO messages " "(mailbox_idnr,messagesize,unique_id,internal_date,stat