[Zope] Thousands of Objects - how do they manifest? (newbie)

[sean.upton@uniontrib.com]

Might not be a bad idea.  One paradigm I have found myself gravitating
towards is hybrid storage.  For example, in an ecommerce site, using a
CMF-backed system to keep catalog entries, and create custom actions and
skin scripts/queries-to-rdbms/etc for associating relational content with
the ID of the catalog entry in the object database, thus maintaining some
sort of relationship between content stored in the ODB, and data stored in a
RDBMS.

Sean

-----Original Message-----
From: Crosbie Fitch [mailto:crosbie@cyberspaceengineers.org]
Sent: Monday, January 06, 2003 10:52 AM
To: zope@zope.org
Subject: RE: [Zope] Thousands of Objects - how do they manifest?
(newbie)


Thanks for the surprisingly prompt and helpful advice everyone. :-)

The primary question I had in my mind was whether persistent objects were
necessarily manifest in a folder. If at least hundreds of users might create
umpteen new objects/records each day, I was wondering if there might be two
kinds of persistent object, i.e. visible and invisible (and whether there
would be performance issues if not). I think this is pretty well answered
now. BTreeFolder2 sounds like a reasonable solution to the folder
containment issue.

However, given that creation of new objects/records (bids) is likely to be
quite frequent and simultaneous by a wide variety of users, I'm beginning to
think that perhaps I'd be better off using an external database. (NB we're
talking around 100K bids per item)

An external database is also likely to help separate out reliability and
scalability issues of the eCommerce data separately from taht of the web
site.

Now down to the external database. I've gathered so far that probably the
best database to start off with would be MySQL for Python (with ZMySQLDA). I
expect this can be swapped out with another SQL database if MySQL starts
creaking under the load.



_______________________________________________
Zope maillist  -  Zope@zope.org
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )