SQL has auto increment keys
Having random uuids play against locality of reference and would lead to disk read thrashing significantly slowing QPS.
https://www.percona.com/blog/2019/11/22/uuids-are-popular-but-bad-for-performance-lets-discuss/
https://vladmihalcea.com/uuid-database-primary-key/
Test the various key startegies RW performance to decide what to do.
SQL has auto increment keys
Having random uuids play against locality of reference and would lead to disk read thrashing significantly slowing QPS.
https://www.percona.com/blog/2019/11/22/uuids-are-popular-but-bad-for-performance-lets-discuss/
https://vladmihalcea.com/uuid-database-primary-key/
Test the various key startegies RW performance to decide what to do.