An insignificant amount for the comparison (why I didn't mention it), it's a fast implementation and the JVM C2 JIT has kicked in by the time the first batch has completed.
replyI can't believe I had to scroll down to this far to see someone making this point.
replyAlso INSERT speed instead of SELECT? Typically most time is spend in SELECT or UPDATE.
Although not as prominent as insert SELECT and UPDATE both benefit from page cache locality, assuming rows that are stored near each other are often selected/updated together.
reply