X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 3EFC7D1B574 for ; Mon, 25 Aug 2003 04:11:11 -0300 (ADT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 11916-07 for ; Mon, 25 Aug 2003 04:10:41 -0300 (ADT) Received: from ns1.keycomm.it (ns1.keycomm.it [62.152.33.7]) by svr1.postgresql.org (Postfix) with ESMTP id DF627D1B8B5 for ; Mon, 25 Aug 2003 04:10:38 -0300 (ADT) Received: from osts (ip-a1-37118.keycomm.it [62.152.37.118]) by ns1.keycomm.it (Postfix) with ESMTP id 4638A1B461 for ; Mon, 25 Aug 2003 09:10:21 +0200 (CEST) Subject: Re: [ZODB-Dev] What are the ZopeDB limit? From: Michele Bendazzoli To: pgsql-sql In-Reply-To: <16199.54838.254837.52529@gargle.gargle.HOWL> References: <1061215015.1742.176.camel@mickymouse.sintel> <16199.54838.254837.52529@gargle.gargle.HOWL> Content-Type: text/plain Organization: Micky Mouse Message-Id: <1061795547.841.22.camel@mickymouse.sintel> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.4 Date: Mon, 25 Aug 2003 09:12:27 +0200 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/293 X-Sequence-Number: 14909 On Sat, 2003-08-23 at 23:01, Dieter Maurer wrote: cut > > What do you think of? > > When your data fits well in a relational database > (a huge number of highly structured records, no full text indexes), > put it in Postgres. Otherwise, try the ZODB. > Make some preliminary mass tests before your invest a lot in one > approach. Thank you very much for your in dept advices. I think i will go for a mixed approach: I'll put the raw data in a db managed by postgresql and documents that reassumes them in the zopedb. This approach let me combining the advantages of both zopedb and postgresql and should prevent future troubles. ciao, Michele p.s. Is there any future planning of integrating the power of postgresql directly in the zopedb? Now that postgresql seems to become a very independent platform database (with a native windows port) maybe can be considered by the zopedb developers as solid ground to store the objects managed by zope.