[Zope] Zope Database Size

[James W. Howe]

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