Sample Header Ad - 728x90

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