[Zope-DB] ZODB capacity

[Matthew T. Kromer]

ben sassi lassaad wrote:

>  
>
> Salut ,
>
> If I well understand  with window 2000  I have to recompile Zope  with 
> python > 2.2.3 like 2.3
>
> Another thing I want to Know what  a bout the capacity of the ZODB 
> file with  Linux or  FreeBSD
>
>  I want to eliminate   problem if  capacity => 60 GO  
>
>  Thanks a lot
>


I don't recommend storing very large objects in the ZODB.  While the 
capacity of the ZODB is huge, it acts as a log file system, ie it 
appends to the end of the file only.  Periodically you must pack the 
database to reclaim unused space.  Packing a 60GB data.fs file would 
take some period of time for just the drive data transfer rates alone.

Large objects (ie BLOB style objects in RDBMS terms) are best stored on 
the filesystem with some other mechanism used to map them into Zope.  
There are a number of fs->zodb mapping tools available, each varying in 
complexity.  The latest style is Shane Hathaway's APE system which lets 
you control the mapping at the object level.

-- 
Matt Kromer
Zope Corporation  http://www.zope.com/