Re: [Dbmail] Message to multiple users

2003-04-01 Thread Curtis Maurand
Groupwise has a very eloquent and efficient design. It scales to very large numbers of users and integrates tightly with Novell eDirectory services (read LDAP). Curtis - Original Message - From: "Roel Rozendaal - IC&S" <[EMAIL PROTECTED]> To: Sent: Tuesday, April 01, 20

Re: [Dbmail] Message to multiple users

2003-04-01 Thread
I'm taking this subject to the development mailing list :-) Magnus Sundberg heeft op dinsdag, 1 apr 2003 om 09:48 (Europe/Amsterdam) het volgende geschreven: Hi again, I have been thinking more of how people store mail on the server. I have another space saving idea. I beleive many people fil

Re: [Dbmail] Message to multiple users

2003-04-01 Thread Magnus Sundberg
Hi again, I have been thinking more of how people store mail on the server. I have another space saving idea. I beleive many people file their sent mail somewhere, I know I file it on the server in a folder named sent. Mozilla mail copies the mail with imap to the sent mail folder. Now there are

Re: [Dbmail] Message to multiple users

2003-03-31 Thread Blake Mitchell
After reading the kind of internal changes required to make this work, one thing does come to mind. It sounds like public folders would solve this problem. And I bet it would take a lot less core changes to dbmail. It wouldn't be as transparent for the users, but perhaps that's a good thing, le

Re: [Dbmail] Message to multiple users

2003-03-31 Thread Aaron Stone
You're correct, I was looking at that and thinking 'gee, why do these link back to one another? without foreign key support, that's a nightmare!' But I don't think there needs to be much more than a few tweaks to the existing tables to get this working. Aaron On Mon, 31 Mar 2003, Magnus Sundberg

Re: [Dbmail] Message to multiple users

2003-03-31 Thread Magnus Sundberg
Hi Aaron, I did not understand your reply, if you look at what is linked with what. I see the following MESSAGEBLK record message_idnr points to a record in the messages table. MESSAGE record message_idnr is UNIQUE. You need to add at least one pointer to the messages table, called something li

Re: [Dbmail] Message to multiple users

2003-03-31 Thread lou
In some email I received from Magnus Sundberg <[EMAIL PROTECTED]> on Mon, 31 Mar 2003 18:34:55 +0200, wrote: > Hello Jeff, > From your database design it looks like that you change the > mailbox_idnr record in the messages table when you move mail from one > mailbox folder to another. I hope th

Re: [Dbmail] Message to multiple users

2003-03-31 Thread Aaron Stone
Actually, I believe that this layer would work fine as it is already. The 'message' table links a messageblk to a mailbox. It could easily be that a single messageblk is referenced by several rows in the message table and therefore appears in several people's mailboxes. Aaron On Mon, 31 Mar 2003

Re: [Dbmail] Message to multiple users

2003-03-31 Thread Magnus Sundberg
Hello Jeff, From your database design it looks like that you change the mailbox_idnr record in the messages table when you move mail from one mailbox folder to another. I hope this is possible at least by the IMAP protocoll? The problem as I see it is the relational database structure itself.

Re: [Dbmail] Message to multiple users

2003-03-31 Thread Jeff Brenton
Hello Magnus, MS> Is there one new MESSAGEBLK created in the database for each user for MS> these messages, or is the MESSAGEBLK shared between the users. Yes, there is a complete message (1 entry into message and 2 or more into messageblk tables) for each recipient. Send a message to 1,000 peopl