Subject Re: [Firebird-Architect] Bulk loader.
Author Vlad Khorsun
> But at the moment I have a problem understanding why we're discussing
> how to apply constraints _during: the load, since the original idea was
> to evaluate them _after_ the load (though I do not have profiling
> numbers from Vlad, some maybe indeed CHECK constrainsts can be evaluated
> during the load).

I told mostly about FK constraint - it is very expencive to check it during load
(or index creation) as such check produced many random reads from parent table(s)

Regards,
Vlad