[Zope-DB] Restriction of ZOPEDB

[Robert Sösemann]

Hello,

in one of our projects we are using ZOPEDB for storage of documents and binary files? On the ZOPE Server the project is running on, we have mayn other ZOPE apps running. As the ZOPEDB of the project has reached a enormous size (1 GB) we are facing performance issues. This is affecting also all the other ZOPE apps on this server.

We are looking for a good alternative (which is minimal invasive to the project code) to improve performance:

The important questions are:
----------------------------
- What are the limits/restrictions of the ZOPEDB due to size and file amount?
- Besides performance issues, which other problems could we get? Especially side effect that affect the other apps on this server).
- Could we switch to using a binary storage outside of the ZOPEDB? Doe you have any experience how much effort that is for a running system?

- Or is it just more efficient to put more "power" (CPU, RAM, HD) on the server?


Thanks for you help and best regards

Robert