On 1/19/07, <b class="gmail_sendername">Morbus Iff</b> <<a href="mailto:morbus@disobey.com">morbus@disobey.com</a>> wrote:<div><span class="gmail_quote"></span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
> One thing I noticed when working with Firebird is for mass imports, it is<br>> almost always much faster to lock the DB, deactivate keys and indexes,<br>> perform the mass operations, and reactivate all once you're over: rebuilding
<br>> the constraints once beats maintaining them on a large set of operations.<br><br>I can attest to this, regardless of benchmarks :)</blockquote><div><br>Me too. I recall in Oracle and Teradata (a datawarehousing DB), it was faster
<br>to drop the indexes altogether, do the mass inserts/updates/whatever, then<br>rebuild the indexes after the fact.<br></div></div>