Skip to content

DEV Community

Databases & UUIDs Series' Articles

Back to Viktor Dorotovič's Series

Cover image for Choose the right primary key to save a large amount of disk I/O

Viktor Dorotovič

Oct 5 '22

Choose the right primary key to save a large amount of disk I/O

#database #performance #algorithms #webdev

9 min read

Cover image for UUIDs Are Bad for Database Index Performance, enter UUID7!

Viktor Dorotovič

Oct 7 '22

UUIDs Are Bad for Database Index Performance, enter UUID7!

#news #database #performance #webdev

7 min read

Cover image for Partitioning InnoDB tables by time-based pseudo-sequential UUIDs

Viktor Dorotovič

Oct 11 '22

Partitioning InnoDB tables by time-based pseudo-sequential UUIDs

#database #mysql #postgres #architecture

12 min read