On Fri, Jul 30, 2004 at 13:05:36 +0200, Michael Bell <[EMAIL PROTECTED]> wrote: > Alessandro Razeto wrote: > > >>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. > > A DBM file with BTree as datamodel is not slower than PostgreSQL which > use the same technology. Nevertheless there is an open discussion in the Hmmmm not really sure. I did some tests some time ago; sql server can be configured using caching proxy and several server load balanced :-) > OpenCA group what we do in the future with our database backends because > we get more and more problems with the DBM backend (searching, ordering > etc.). If we completely switch to SQL databases then we can touch the > database interface much more agressive (because SQL is much more > powerful than DB_File). The only problem is that SQL databases has no > real standard for BLOB handling. > > 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
