[Zope] Making Zope stop storing old object versions

[Sinang, Danny]

How do I go about replacing a Catalog using MySQL ? This is the first
time I've heard this. 

-----Original Message-----
From: Jonathan [mailto:dev101 at magma.ca] 
Sent: Thursday, May 08, 2008 7:16 PM
To: Sinang, Danny
Cc: zope at zope.org
Subject: Re: [Zope] Making Zope stop storing old object versions

>> Sinang, Danny wrote:
>> Hello,
>>
>> We've got lots of Catalog reads and writes and our Data.fs is growing

>> at an immense rate.
>>
>> Is there a way we can tell Zope to stop storing old object versions 
>> to limit the growth and not have to pack that often ?
>
>Well in fact it (Filestorage) does only "store" new object versions.
>What it does not is removing the old version - this is done during
packing.
>
>When you have many Catalog writes or other parts of your object tree 
>experiences many writes, try to mount an extra ZODB (and storage)
there.
>
>You can also try some of the other storages like relstorage (where it 
>depends on the RDBMS how it handles writes)

Alternatively, you could just replace your Catalog with an external db
such as MySQL (using zmysql database connections).


Jonathan