That helps, but I'm more interested on knowing if there is a size issue. Does performance degrade once the database gets to a particular size, for example. I think, performance not withstanding, that the data I want to store would fit better in a ZODB than an external database. Thanks. At 04:26 PM 2/3/00 +0000, Chris Withers wrote:
James,
Take a look at http://www.zope.org/Members/anthony/sql_vs_ZODB for some views on this subject.
Chris
"James W. Howe" wrote:
At what point does it make sense to store data outside of the ZODB? For example, I have a site which wants to have access to a news article archive. If the articles were stored in Zope, the ZCatalog searching would make this task almost trivial. I'm concerned about the size of the database, however.
The archives may go back several years and represent information from a weekly news publication. I have a sample archive of one "issue" which constitutes about 130k of raw text (no graphics at this point). I expect that a typical "issue" may be around 130k - 200k. If I store that information in Zope, probably as instances of a ZClass with properties to hold some information and perhaps DTMLMethods to hold the many article content, how many weeks of archive information could I reasonably store in Zope before the thing would become too big?
This archive solution is likely to be replaced in the future so I'm interested in finding a solution which is simple and quick to implement but will provide adequate performance for my users.
Any info on this subject would be appreciated.
Thanks.
James W. Howe mailto:jwh@allencreek.com Allen Creek Software, Inc. pgpkey:
http://ic.net/~jwh/pgpkey.html
Ann Arbor, MI 48103
_______________________________________________ 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 )
James W. Howe mailto:jwh@allencreek.com Allen Creek Software, Inc. pgpkey: http://ic.net/~jwh/pgpkey.html Ann Arbor, MI 48103