Leave the Sata barrier aside. Im taking about a controller that would use spinning disk instead of nand flash storage and provide optimal read/writes through pci express lanes
You can't leave any barrier/bottleneck behind.
And while scanning through this thread, I didn't see where the actual writing of the data to disk was addressed. That takes time too because the R/W has to physically (via magnetic impulses) reorient the magnetic particles on the disk. As they get smaller and smaller (with greater densities) reorienting takes less time, but it will never be as fast as flipping a 0 to a 1 with SS storage devices. This is why the slowest SSD can run circles around the fastest HD, even SSHDs.
It does not matter how much data and how fast that data comes through the interface - actual reading and writing the data will always be a big (tiny?) bottleneck.
And of course, it takes time for the read/write head to swing back an forth then properly center itself over the track - even after the disk is defragged.
as long as it is a sequential read/write and doesn't have to constantly jump from one track to another.
But constantly jumping from track to track is inevitable and unavoidable. Even if the drive 100% defragged (not likely) every file needed will NOT be in sequential order. And most files are tiny so the R/W head will have to jump back and forth to get to the next file location.
Physical space isn't the point so much as magnetic fields are physically smaller than transistor gates.
Yes, but that creates a problem in itself. It still takes energy to flip and flop those gates. But you can't have those magnetic fields interfering with the state of any adjacent gate. So field has to be tiny enough to affect only the intended gate but at the same time, strong enough to physically flip (or flop) it. That takes some extremely precise positioning - and that also takes time.
I agree with
Spinning Hard Drives will be here for years yet.
But they will be here
ONLY because they still offer more storage for the $$$. As soon as SS storage becomes cheaper than HD storage, HDs will rapidly go the way of the 8-Track. And note - especially when it comes to data centers - it is not just about the cost of the drive. HDs consume more energy, generate more heat, weigh more, take up more space, make noise, and of course, don't perform as well.