Return-Path: Delivered-To: apmail-db-ddlutils-user-archive@www.apache.org Received: (qmail 76159 invoked from network); 21 Jan 2007 19:55:17 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 21 Jan 2007 19:55:17 -0000 Received: (qmail 75380 invoked by uid 500); 21 Jan 2007 19:55:23 -0000 Delivered-To: apmail-db-ddlutils-user-archive@db.apache.org Received: (qmail 75359 invoked by uid 500); 21 Jan 2007 19:55:23 -0000 Mailing-List: contact ddlutils-user-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: ddlutils-user@db.apache.org Delivered-To: mailing list ddlutils-user@db.apache.org Received: (qmail 75348 invoked by uid 99); 21 Jan 2007 19:55:23 -0000 Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 21 Jan 2007 11:55:23 -0800 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: pass (herse.apache.org: local policy) Received: from [69.55.235.182] (HELO mvdb.net) (69.55.235.182) by apache.org (qpsmtpd/0.29) with SMTP; Sun, 21 Jan 2007 11:55:14 -0800 Received: (qmail 21336 invoked from network); 21 Jan 2007 19:54:53 -0000 Received: from unknown (HELO [10.21.21.28]) (80.126.215.98) by 69.55.235.171 with SMTP; Sun, 21 Jan 2007 19:54:53 +0000 Message-ID: <45B3C516.9070302@mvdb.net> Date: Sun, 21 Jan 2007 20:55:02 +0100 From: Martin van den Bemt User-Agent: Thunderbird 1.5.0.9 (X11/20061222) MIME-Version: 1.0 To: ddlutils-user@db.apache.org Subject: Re: Performance Problems ? References: <20070119181538.81773.qmail@web34402.mail.mud.yahoo.com> In-Reply-To: <20070119181538.81773.qmail@web34402.mail.mud.yahoo.com> Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Checked: Checked by ClamAV on apache.org Could you put this into JIRA ? I cannot make any promises I have time for this soon though... Mvgr, Martin Laurent ROCHE wrote: > Hi, > > Is there any one here using DDL-Utils with significant volumes of data (data.xml of a few Mb) ? > My data.xml file is of 44 686 lines of data and 4 7734Kb of data. > > I am exporting data from a PostgreSQL database to Derby database. > When inserting into a DB without any foreign keys, primary keys, indexes, it's fast (actually faster with DDL-Utils than with insert scripts running ij): a couple of minutes (40s for DDL-Utils). > > But when running with keys and indexes, DDL-Utils takes 2 hours ! ! ! > > Running DB-Unit takes only 5, 6 minutes ! > > So I am back to my idea where it would nice to get the export to generate the data file according to an order, so that during import I do not have to use the ensureforeignkeyorder="true" option. > (see http://mail-archives.apache.org/mod_mbox/db-ddlutils-user/200701.mbox/%3c20070108161758.43099.qmail@web34402.mail.mud.yahoo.com%3e ) > Ideally, DDL-Utils will generate the table orders it-self by reading the dependencies at the schema level (foreign keys). > But at least, if I could give DDL-Utils the tables order: that will be great ... otherwise I will have to stop using DDL-Utils for data: that I will be a shame ! > > > > Have fun, > L@u > The Computing Froggy > > > > > > > > > ___________________________________________________________________________ > D�couvrez une nouvelle fa�on d'obtenir des r�ponses � toutes vos questions ! > Profitez des connaissances, des opinions et des exp�riences des internautes sur Yahoo! Questions/R�ponses > http://fr.answers.yahoo.com > >