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 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
