[Zope] ZODB vs SQL

Geir Bækholt Geir Bækholt <geirh@funcom.com>
Wed, 15 Jan 2003 16:08:06 +0100


on or about, Wednesday, January 15, 2003, we have reason to believe that ab=
orel wrote
something along the lines of :
> In "Choosing to store data in SQL vs ZODB" located=20
> http://www.zope.org/Members/anthony/sql_vs_ZODB
[snip..]
> Does that mean that the changes AND the old version of the object are=20
> kept in ZODB =3F

Yes. Every transaction is appended to the data.fs-file.

> If it's true, is packing a good way to throw away the old versions of=20
> the object =3F

Yes.

If you have an application that causes your data.fs to grow, you might
consider using cron or something similar to pack automatically at
regular intervals.

--=20
Geir B=E6kholt        geir@funcom.com
Web Application/HCI-designer
Product Operations
Funcom Oslo