[Zope-DB] Re: Which objects can be stored in Data.fs
2) is it possible to tell zope NOT to store some things in the database (for instance in zope.conf-I've looked but not too closely and found nothing) Why don't you run a cron job that packs the database, let's say each month? You could also do a backup before packing; just in case you want to undo something later. Something that would be nice, would be to be able to store transactions in a separate file before packing, but I don't think it is posible in Zope. You may have to write something to do this. Regards, Josef ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db
Re: [Zope-DB] Which objects can be stored in Data.fs
[EMAIL PROTECTED] > After a successful Database packing (thanks to Dieter!), I compared the > old and new sizes of my databases. From 26 GB, it was 320 Mb after > packing. > > I thought there was too much difference between both. I watched closely at > the progression of my new database, and realised it had gained 100 MB in > just a day ! > > So I went to the "undo" part of the ZMI, and I saw that zope stored in the > database every, EVERY transaction, that means even the simple fact of > VIEWING a page. A transaction adds info to the database if and only if a persistent object was modified during the transaction -- and it's the _purpose_ of a database to keep track of changes to persistent objects, so that's necessary. Viewing a page alone should not be enough to modify the state of any persistent object. More must be going on than you currently know about. You can use fsdump.py to find out which objects are changing: http://zope.org/Wikis/ZODB/FileStorageBackup > I began to understand why it increased so dramatically. > > So my questions are: > > 1) is it normal ? If and only if you're running applications that do excessive modification of persistent objects ;-) > 2) is it possible to tell zope NOT to store some things in the database No, and it doesn't make sense (as above, it's the database's purpose to keep track of changes; if "too many" changes are happening, the cure is to find the software responsible for making those changes, and alter it to stop making so many changes). > ... > PS : I use zope 2.7.2 ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db
Re: [Zope-DB] Which objects can be stored in Data.fs
On 6 Oct 2005, at 14:00, [EMAIL PROTECTED] wrote: So I went to the "undo" part of the ZMI, and I saw that zope stored in the database every, EVERY transaction, that means even the simple fact of VIEWING a page. I began to understand why it increased so dramatically. So my questions are: 1) is it normal ? 2) is it possible to tell zope NOT to store some things in the database (for instance in zope.conf-I've looked but not too closely and found nothing) 1) It is not normal and usually caused by badly written software that you run on top of Zope. 2) No. jens ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db
[Zope-DB] Which objects can be stored in Data.fs
Hi After a successful Database packing (thanks to Dieter!), I compared the old and new sizes of my databases. From 26 GB, it was 320 Mb after packing. I thought there was too much difference between both. I watched closely at the progression of my new database, and realised it had gained 100 MB in just a day ! So I went to the "undo" part of the ZMI, and I saw that zope stored in the database every, EVERY transaction, that means even the simple fact of VIEWING a page. I began to understand why it increased so dramatically. So my questions are: 1) is it normal ? 2) is it possible to tell zope NOT to store some things in the database (for instance in zope.conf-I've looked but not too closely and found nothing) PS : I use zope 2.7.2 Thanks a lot ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db
