On Fri, Jul 30, 2004 at 11:32:16 +0200, Michael Bell <[EMAIL PROTECTED]> wrote: > Ives Steglich wrote: > > > >Question abaut the used dbm stuff - just some thoughts for the next > >steps not the current release ,o) > >for the moment the current solution should be sufficient and also be > >able to handle some ten of thousends of mails > > > >it uses $key, $value; my current implentation just stores the msg-ids > >and the messages itself are still save in the mail-dirs, can we put the > >mail-msg as value in those dbms? this can be done in the per maildir dbm > >file for example, so we avoid the 'problems' with large volumes of mail > >and don't get ten of thousends of mail in an directory - i think dbms > >can handle this - or? > > > >since the msg-id is the key and the msg itself would be the value, but i > >havn't work so much with this dbm stuff, so i just don't know > >also in the question of speed and so on... > > It's no problem to store a mail in the database instead of "1" but > please think about the size of this file: > > 2.000 bytes per encrypted PIN mail > 1.000.000 users > --------------- > 2 GB of data > some overhead for the organization > --------------- > --> one single file which is greater than 2GB >From a thechical point of view one so large dbm file will be quite slow, and I'm not really sure it will be better than several milion of inodes. The overstress of the fs can be reduced using a fs optimized for fast inode access, like in linux reiserfs. Using a postgresql server would be much better. > > Nevertheless this is better than one directory with one million files. > BTW a modern Unix should be able to handle such large files (Solaris, > AIX, Linux 2.6 and BSDs should already support this today). > > Michael > -- > ------------------------------------------------------------------- > Michael Bell Email: [EMAIL PROTECTED] > ZE Computer- und Medienservice Tel.: +49 (0)30-2093 2482 > (Computing Centre) Fax: +49 (0)30-2093 2704 > Humboldt-University of Berlin > Unter den Linden 6 > 10099 Berlin Email (private): [EMAIL PROTECTED] > Germany http://www.openca.org > > > > ------------------------------------------------------- > This SF.Net email is sponsored by OSTG. Have you noticed the changes on > Linux.com, ITManagersJournal and NewsForge in the past few weeks? Now, > one more big change to announce. We are now OSTG- Open Source Technology > Group. Come see the changes on the new OSTG site. www.ostg.com > _______________________________________________ > OpenCA-Devel mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/openca-devel
------------------------------------------------------- This SF.Net email is sponsored by OSTG. Have you noticed the changes on Linux.com, ITManagersJournal and NewsForge in the past few weeks? Now, one more big change to announce. We are now OSTG- Open Source Technology Group. Come see the changes on the new OSTG site. www.ostg.com _______________________________________________ OpenCA-Devel mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/openca-devel
