Do databases optimize random write and read operations?
-2
votes
1
answer
786
views
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.
Asked by Tim He
(223 rep)
Feb 22, 2021, 02:02 PM
Last activity: Feb 25, 2021, 12:50 AM
Last activity: Feb 25, 2021, 12:50 AM