5 ms·
How much time is `(random-uuid7-bytes)` taking?
by michaelcampbell 3mo ago
How much time is `(random-uuid7-bytes)` taking?
- u1hcw9nx 3mo agoI can't believe I had to scroll down to this far to see someone making this point. Also INSERT speed instead of SELECT? Typically most time is spend in SELECT or UPDATE.
- andersmurphy 3mo agoAlthough 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.
- andersmurphy 3mo agoAn 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.