Vlad Khorsun wrote:

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

Indeed. But is it cheaper to run it later?

--
James Starkey, Senior Software Architect
MySQL Inc., Manchester, MA, USA, www.mysql.com
Office: 978 526-1376