[development] Referential integrity -- finally?
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
> > almost always much faster to lock the DB, deactivate keys and indexes,
> > perform the mass operations, and reactivate all once you're over:
> > the constraints once beats maintaining them on a large set of
> I can attest to this, regardless of benchmarks :)
Me too. I recall in Oracle and Teradata (a datawarehousing DB), it was
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...
More information about the development