[Zope-PTK] Sizing questions

[Tres Seaver]

Lucas Hofman wrote:
> 
> This message is cross-posted to both the zope and the PTK mailing lists.
> The restrictions I hope to hear about might be in both products.
> 
> 1. The ZODB database we are using has passed 500 MB in Size (Yes, it is
> packed). It is about 50/50 populated with small news items and files of
> 1-4Mb in size. I expect it to pass 1 GB in 6-12 months. At present
> response is very good, both in retrieving items and in accessing the
> catalog. Does anyone has experience with much larger databases? Are
> there any build in limits that I should take into account.

Depending on the operating system, there may be a 2 Gb limit to the
size of the database;  in any case, you need a recent cut of Zope to
allow you to use files larger than 2 Gb.

In your specific design, I might consider storing the large files
externally, using a product like LocalFS, which "mounts" a filesystem
directory into a Zope database.  This would keep the size of your
database down, and allow you to access/tweak/backup the files
outside of Zope.
 
> 2. The portal user administrion is based on a ACL-users folder. 70 users
> at present, expected to reach 500-1000 after we disallow anonymous
> viewing. Will that still work?

The www.zope.org portal currently has over a thousand members;  some
parts of the site, the "all member folders" page in particular, are a
bit painful at that size.  A different underlying implementation (b-tree
instead of hashing), and a batching UI would solve most of that problem.

Tres.
-- 
=========================================================
Tres Seaver                          tseaver@digicool.com
Digital Creations   "Zope Dealers"   http://www.zope.org