Re: [Zope-DB] Re: Which objects can be stored in Data.fs

2005-10-10 Thread Chris Withers

[EMAIL PROTECTED] wrote:

Oh I'm sorry, I thought this list was appropriate...
What is the original purpose of this list ?


Relational Database usage within Zope.


(and which one could be the most appropriate for the problems I focus on,
according to you ?)


Either of the ones I mentioned before...

Chris

--
Simplistix - Content Management, Zope & Python Consulting
   - http://www.simplistix.co.uk

___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db


Re: [Zope-DB] Re: Which objects can be stored in Data.fs

2005-10-07 Thread rdl3
> Josef Meile wrote:
>
> Urm, in this case, I'd suggest the guy should really find out what's
> causing those writes, they're likely impacting heavily on performance,
> if nothing else...

Yes that's what I'm doing now... I have an impression that it affects also
RAM
...
>

>
> PS: Any chance this thread could move to a more appropriate list, oh, I
> dunno, say zodb-dev@zope.org or [EMAIL PROTECTED]
>

Oh I'm sorry, I thought this list was appropriate...
What is the original purpose of this list ?
(and which one could be the most appropriate for the problems I focus on,
according to you ?)

Thanks a lot
Renaud

___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db


[Zope-DB] Re: Which objects can be stored in Data.fs

2005-10-07 Thread Josef Meile

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.



Huh? not sure what you mean... if you keep the .old file created during 
packing, that has all the transactions in it that would have been packed 
away...

I was just thinking about only keeping a log file with the transactions
without the data and let's say apply it to a packed Data.fs. It was just
a nice-to-have idea, nothing else. But I think for the OP would be
enough to keep the Data.fs.old as you said.

___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db


Re: [Zope-DB] Re: Which objects can be stored in Data.fs

2005-10-07 Thread Chris Withers

Josef Meile wrote:

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.


Urm, in this case, I'd suggest the guy should really find out what's 
causing those writes, they're likely impacting heavily on performance, 
if nothing else...



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.


Huh? not sure what you mean... if you keep the .old file created during 
packing, that has all the transactions in it that would have been packed 
away...


cheers,

Chris

PS: Any chance this thread could move to a more appropriate list, oh, I 
dunno, say zodb-dev@zope.org or [EMAIL PROTECTED]


--
Simplistix - Content Management, Zope & Python Consulting
   - http://www.simplistix.co.uk

___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db


Re: [Zope-DB] Re: Which objects can be stored in Data.fs

2005-10-07 Thread Jens Vagelpohl


On 7 Oct 2005, at 08:27, [EMAIL PROTECTED] wrote:


ok thanks,
The software responsible for this problem is Nuxeo CPS (Collaborative
Portal Server), which is based upon CMF (I think CMF itself is well- 
tested
enough not to be accused  of being responsible) and is very similar  
to the

maybe best-known Plone.
(By the way does anyone would know if this happens also with plone ?)

Anyway, I'm gonna ask on CPS mailing lists to see if this is a  
(hopefully

corrected in new realeases) bug or if this is not well known.


You need to do a little homework first. Try to find out *what* is  
writing to the database, what objects get changed. The Undo log might  
have some clues, otherwise use a ZODB analyzing tool like Tim suggested.


jens

P.S.: The CMF does *not* write to the database when you view content,  
that's for sure.


___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db


Re: [Zope-DB] Re: Which objects can be stored in Data.fs

2005-10-07 Thread rdl3
ok thanks,
The software responsible for this problem is Nuxeo CPS (Collaborative
Portal Server), which is based upon CMF (I think CMF itself is well-tested
enough not to be accused  of being responsible) and is very similar to the
maybe best-known Plone.
(By the way does anyone would know if this happens also with plone ?)

Anyway, I'm gonna ask on CPS mailing lists to see if this is a (hopefully
corrected in new realeases) bug or if this is not well known.

Thanks all again for your help...

___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db


[Zope-DB] Re: Which objects can be stored in Data.fs

2005-10-06 Thread Josef Meile

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