Subject | Re: [firebird-support] Temporary disable FK constraint |
---|---|
Author | Scott Morgan |
Post date | 2015-11-09T11:21:03Z |
On 06/11/15 19:21, Helen Borrie helebor@... [firebird-support]
wrote:
mins to import, without, 4 mins (that includes the time to drop/recreate
the constraints)
+50% speed-up, multiplied by a bigger dataset, multiplied by all the
deployed DB instances that'll need this update. Worth the effort.
Scott
wrote:
> Still, I'm bemused as to why you want to fiddle with the constraintsWell, to give some rough data; with constraints, my test case takes 10
> if you're not changing them.
mins to import, without, 4 mins (that includes the time to drop/recreate
the constraints)
+50% speed-up, multiplied by a bigger dataset, multiplied by all the
deployed DB instances that'll need this update. Worth the effort.
Scott