CreamFilling512 said:Bass said:*snip*
No way man, the OS has no knowledge of the internal structure of the database. You can certainly get better performance by doing more work. Database servers optimize their layout on the physical disk.
You can optimize the internal structure of the database such that the OS will optimize reads to the fullest.
It's really no different then optimizing instructions, you have no control over branch prediction and cache usage on an x86 processor. But you can still optimize code for branch prediction and cache, by modifying the structure of your program.