Re:How would you build an operating system? (SerenityOS with...
by bzzzt on Wednesday February 07, 2024 @07:01AM
(#39287497)
Oracle also had (has?) the capability to split up database volumes on raw disks based on I/O load.
Re:How would you build an operating system? (SerenityOS with...
by user8501 on Wednesday February 07, 2024 @12:21PM
(#39291261)
SQLite essentially achieves this as well by keeping the entire database in one file. It’s even faster than the filesystem in some cases: https://www.sqlite.org/fasterthanfs.html
Both Oracle RDBMS and older versions of Microsoft SQL Server had the option to use "raw disk devices" / "raw partitions" instead of the filesystem. It had some obvious justifications such as avoiding the "wasteful double buffering" of the file system cache being redundant to the database's cache and avoiding "unnecessary" extra i/o abstraction layers.
Microsoft later got rid of that option because it wasn't worth the tradeoff of a small performance gain while losing the easier management aspects of NTFS file system.