mike gallagher wrote:

Two questions: 1. Is it good practice to store all my content (press releases, news stories etc) in an external relational database? I think this will ensure that if the company decide to get rid of Zope, it'll be easier to re-use the content. Is this overkill? Is it easy to export content from the Zope OO database into a relational db? (Yes,I'm a newbie!)

If your data is tabular in content, it is no more diffucult to pull out the data from Zope than from a sql based db. Something like the below simplified code will do it for you. articles = self.ZopeFind(self, obj_metatypes='article', search_sub=1) con = openDB() # pseudo code for article in articles: sql = """ INSERT INTO articles (title, summary, content) VALUES (?,?,?) """ con.execute(sql, (article.title, article.summary, article.content)) con.close() regards Max m

Casey, I read this thread with some interest because I am facing a decision of a similar sort. I am a fan of putting all of the content of our site into the Zope DB but am meeting with skepticism from some. Since ZODB has the distinction of being an object database and several attempts at that technology in the past have met with less than optimum performance results as the database grew (think ObjectStore), a few people seem to think an Rdb would be better suited. I would really like to be able to provided them with some performance benchmarks related to ZODB. Do you have anything available that shows performance of the ZODB as the database grows to say 20GB or 100GB? Are there any available statistics related to the size of machine needed to support a large user community of say 10K with a database that size? I know a lot of this is very subjective regarding users and usage estimation, but anything you have would be a great help. Thanks, Kevin -----Original Message----- From: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of Casey Duncan Sent: Tuesday, April 02, 2002 11:34 AM To: mike gallagher Cc: zope@zope.org Subject: Re: [Zope] future-proofing content I might suggest that designing an application without knowing for sure what platform you will be using is a recipe for disaster. Decide whether you will be using Zope or not *before* you build the whole app. That said, I think the extra work in storing content in the database will only be worth it if you know that other applications besides zope will need direct access to it through a SQL interface. Even if you store all your content in Zope objects (which has many advantages IMHO), you can easily access it externally using XML-RPC. OTOH, if you choose to use a relational back-end, you should check out the DBObjects product. I have not myself used it, but I think it is ained right at solving this problem. -Casey mike gallagher wrote:

Hi all, I'm about to start an intranet project using Zope. I'm new to the tool but am really excited about using it.

Two questions: 1. Is it good practice to store all my content (press releases, news stories etc) in an external relational database? I think this will ensure that if the company decide to get rid of Zope, it'll be easier to re-use the content. Is this overkill? Is it easy to export content from the Zope OO database into a relational db? (Yes,I'm a newbie!)

2. Anyone have any experience/opinions of using Documentum as a data source?

Thanks in advance!

===== Best regards, Mike Gallagher

__________________________________________________ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://http://taxes.yahoo.com/

_______________________________________________ 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 )

_______________________________________________ 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 )

Kevin Carlson writes:

.... I would really like to be able to provided them with some performance benchmarks related to ZODB. Do you have anything available that shows performance of the ZODB as the database grows to say 20GB or 100GB? I do not have benchmarks. But my feeling says, I should not index GB's of data with a ZCatalog.

See the mailing list archives for experiences with ZCatalog and large amounts of data. Since these times, ZCatalog has much improved, but I still think, I is only good for a moderate amount of objects... Dieter