Chris, Six or seven tables/datasets and very small amounts of data from a handful of users. My original question was whether it was bad from a philosophical or practical perspective to use ZODB to store user data. The answer appears to be 'no'. I'm currently using a File object for each record and storing the data as Properties. My record creation script uses the input form data in my Formulator forms to define the File Properties so any changes I make in the input form are automatically reflected in new data records. I thought about using ZClasses to define data objects but someone suggested ZClasses had problems I didn't want to deal with. Thanks, Tom P. Allred, MCSE, RHCE, CCNA Allred Data Consulting, Inc. 704-633-0311 x826 www.AllredData.com Tom@AllredData.com -----Original Message----- From: Chris Withers [mailto:chrisw@nipltd.com] Sent: Thursday, June 05, 2003 5:26 AM To: Andreas Jung Cc: Stan Baptista; Dennis Allison; Tom P. Allred; 'J Cameron Cooper'; zope@zope.org Subject: Re: [Zope] Storing Data inside Zope Andreas Jung wrote:
there is some point in terms of performance, size, reliability and usability where I would choose a commercial fulltext system over Zope. It is hard to say where is point is. The largest fulltext database I have ever build had about 10 million documents and about 60-70 GB of texts..I can not imagine having stored all these docs inside the ZODB + indexes.
It would certainly be interesting to try ;-) What solution did you use for the above in the end? cheers, Chris PS: What number and size of documents are involved in the project being discussed in this thread?