Comment by pkulak
18 hours ago
Yeah, this is 99% of the benefit for me. And it's not theoretical. My company saw performance issues using pure random IDs with MySQL way back in 2015; and consequently rolled our own UUIDv7 that we're still using to this day.
Similar experience here. Random guids as primary keys quickly fragment your table and indexes. You'll need to defrag frequently.