[Zope] huge Data.fs

[Sam Gendler]

Tomaso Scarsi wrote:

> Hi,
> I'm using zope2.0.1 on linux;
> i've built some little sites based on squishdot with about 200 postings;
>
> today I wanted to backup the var/Data.fs and I noticed that the file size
> it's over 100Mb;
>
> all I want to know is if this size it's normal or maybe there's something
> wrong.
>
> thanks
>
> .--------------------------------------------------------------.
> |      .--.                                                    |
> |     |o_o |                                                   |
> |     |:_/ |      Tomaso Scarsi   heimat@www.maldura.unipd.it  |
> |    //   \ \     C.I.S. Maldura                               |
> |   (|     | )    Facolta' di Lettere                          |
> |  /'\_   _/`\    Universita' di Padova                        |
> |  \___)=(___/                                                 |
> `--------------------------------------------------------------'
>
> _______________________________________________
> Zope maillist  -  Zope@zope.org
> http://lists.zope.org/mailman/listinfo/zope
> **   No cross posts or HTML encoding!  **
> (Related lists -
>  http://lists.zope.org/mailman/listinfo/zope-announce
>  http://lists.zope.org/mailman/listinfo/zope-dev )

You probably have lots of revisions to the objects in your ZODB.  This rapidly
inflates the size of the file.  Try going to the control panel and selecting
database management.  If you are comfortable with your site as it is currently,
just delete all transactions older than 0 days.  This will remove all previous
versions of the objects.  If you are more paranoid, only delete objects older
than a couple of days old.  This will leave you with some ability to undo your
changes.  If you delete all the old transactions, your ZODB will be scarcely
bigger than the byte count of the various objects in your zope site.

--sam