Hi Guys & Gals, OK, I am not really complaining here that DDL-Utils is too quick and too good to be true (I am not that mad ... just half crazy).
But ... before when I was running a decent size import, it was taking 2 hours (see original post below). That was running the import when the option "useexplicitidentityvalues=true" has a slight bug and then effectively running as "useexplicitidentityvalues=false". Now with "useexplicitidentityvalues=true" working, the import takes only 1min30sec: great, fantastic ! But, I thought it will fail while inserting because it's inserting rows in table A which has a foreign key on table B which I assummed is not populated yet ! ? ! So the real question is why is DDL-Utils not failing when importing rows on tables with foreign keys constraints ? Does it do a special insert with no constraint checks ? Cheers, [EMAIL PROTECTED] ----- Message d'origine ---- > 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/[EMAIL >> PROTECTED] ) >> 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 ! >> >> ___________________________________________________________________________ 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
