[development] Referential integrity -- finally?

Khalid B kb at 2bits.com
Mon Jan 22 04:25:51 UTC 2007


On 1/19/07, Morbus Iff <morbus at disobey.com> wrote:
>
> > One thing I noticed when working with Firebird is for mass imports, it
> is
> > almost always much faster to lock the DB, deactivate keys and indexes,
> > perform the mass operations, and reactivate all once you're over:
> rebuilding
> > the constraints once beats maintaining them on a large set of
> operations.
>
> I can attest to this, regardless of benchmarks :)


Me too. I recall in Oracle and Teradata (a datawarehousing DB), it was
faster
to drop the indexes altogether, do the mass inserts/updates/whatever, then
rebuild the indexes after the fact.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/development/attachments/20070121/5ac4662d/attachment.htm 


More information about the development mailing list