Random write/read is slower than sequential for HDDs and some SSDs. Some database operations (
UPDATE .. WHERE ..) may cause many random writes/reads. So I want to know if modern databases implement mechanisms to optimize them (e.g., innodb_flush_neighbors in MySQL).
The database can be relational, key-value, No-SQL, or any other kinds of databases.