20 Jan
2007
20 Jan
'07
2:04 a.m.
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