[development] Referential integrity -- finally?

Morbus Iff morbus at disobey.com
Sat Jan 20 01:04:00 UTC 2007


> 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 :)

-- 
Morbus Iff ( keep out of reach of children )
Technical: http://www.oreillynet.com/pub/au/779
Culture: http://www.disobey.com/ and http://www.gamegrene.com/
aim: akaMorbus / skype: morbusiff / icq: 2927491 / jabber.org: morbus


More information about the development mailing list