On Wed, Dec 10, 2003 at 11:11:52PM -0800, Michael Watkins wrote:
> Off topic - I need to quickly build a simple membership list management
> app - the list will have 100,000 - 200,000 Persons() and zero or more
> history/activity objects associated with each Person(). Nothing terribly
> complex in terms of object model.
>
> Lookup/search will be the most common activity. After three months, the
> application will have outlived its usefulness.
>
> I've never worked with a ZODB database of that size (perhaps its
> trivial) and wonder what pitfalls might lie ahead, if any. The front end
> will be Quixote. Thoughts appreciated.

You probably will have to increase the ZODB cache size.  Also, you
might want to use BTrees instead of dictionaries since accessing one
element in the dict causes all the entries to become ghosts.  Our
largest DB has around 250000 objects in it.

  Neil