Thanks for the reply and sorry about the HTML (had Outlook re-installed recently).
Yes, I do mean ZODB (just wanted to indicate that I am using it in a Zope context and not stand-alone).
I'll try and compile a test case as suggested by Toby and see if I can reproduce the problem.
B.t.w. the only possibly "interesting" (read unstable ;) product I have installed is my own! So I AM probably the cause of my own problem (not that it takes me nearer to the solution though).
What I also did not mention is that I am adding and retrieving the messages through XML-RPC, don't know if that's got anything to do with my problem though.
I have in the mean time started moving the finely grained stuff over to a relational DB (yuck) and that should help.
I saw that the data.fs file grew quite rapidly with a lot of finely grained operations, what's the best way to curb this? Packing every now and again? How do I do that programatically?
Regards
Etienne
>Etienne,
>Firstly, please don't post in HTML.
>Etienne Labuschagne wrote:
>> Hmm, it seems as if I am the only one with this problem.
>Seems so, you got any interesting Products or External Methods (or
>pactches/monkey fixes/etc) installed?
>> It is probably best to move the very finely grained data into a
>> relational type DB - I'm not sure that Zope is great for a lot of small
>> object creation/deletion cycles anyway.
>I presume you mean 'ZODB', not 'Zope'. And I'd disagree. The number of
>creation/deletion cycles only influences the size at which a filestorage will grow.
>cheers,
>Chris