Re: Performance of a integrity check during insertions

[Peter Zaitsev]

Any chance of sharing this program ?

This looks pretty strange.

At fitst I would check if validation is problem at all - what is the throughtput if you do not have validation at all ? For example it could be database buffer becomes dirty which limits performance not check itself ? This would explain why breaks in the test which let it to flush dirty pages improve performance.

UNION can be faster on slower depending on amount of rows could match to the ranges.
In your case it should be slower as each of the clauses will have to scan pretty large portion of the table as it can possibly use only one keypart.