MySQL Forums
Forum List  »  Performance

Re: Performance of a integrity check during insertions
Posted by: Peter Zaitsev
Date: March 10, 2005 05:00PM

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.

Options: ReplyQuote

Written By
Re: Performance of a integrity check during insertions
March 10, 2005 05:00PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.