Streaming video from the internet does not use the SSD at all, and a high-quality 1080p video file is maybe 5-10 MB/s of bitrate, you can easily pull that off a spinning HDD that was manufactured 20 years ago.
Video editing at 4K or 8K is one of the few use-cases where NVMe's sequential performance does provide a big benefit... assuming you are not editing using proxies.
Optane's QD=1 random-4K performance does present an opportunity for big speedups on consumer use-cases. But Intel really has to get the prices down if they want to see consumer adoption, right now there is an obvious benefit to cheaper SATA SSDs that allow you to get more data off spinning-rust drives vs a smaller, massively expensive Optane drive (even if it is incredibly fast).
Also, on PS3 it runs in less than 256 MB of RAM... where is it loading these assets to? Most games have RAM consumption on the order of 4-8 GB in most situations, not all of that is assets, and not all of that is read sequentially.
On the other hand, Optane does have a big advantage at QD=1, which is the point people are making here. Looking at NVMe as an indication of Optane performance is the wrong approach since it has very different performance characteristics.
https://img.purch.com/r/711x457/aHR0cDovL21lZGlhLmJlc3RvZm1p...
(of course you're not incorrect that games aren't really using access patterns that are optimal for superfast SSDs)
Anyway, the big difference with Optane is that its performance is more similar to having more system memory. I have not benchmarked this, but I believe a system with just 8GB ram + Optane will run better than a system with 16GB ram and Samsung 970 pro for workloads using up to 16GB of ram. There is a reason Intel announced its memory drive technology for Optane DC4800x https://www.intel.com/content/www/us/en/software/intel-memor...
EDIT: adding a link to lwn.net article explaing the use of swap/memory overcommit https://lwn.net/Articles/704478/
No, not even close. PCIe is still way slower than DDR4. Once your working set grows beyond available RAM, the Optane SSD will be a better swap device than any flash-based SSD, but you still notice your system slowing down drastically from all the swap activity.
Intel's Memory Drive Technology is really intended for situations where you have multiple Optane SSDs, and a workload that wants a large amount of total RAM but seldom has a true working set larger than actual DRAM capacity.
Traversing the root complex can take upto 100 cpu cycles each way.
PS: DDR4-3200W in quad channel mode is crazy fast and should break 100GB/s though sill a long way from a 1080Ti 484 GB/s.
Also because that was a bottleneck. Now the CPU is often the bottleneck, so I doubt you'd notice Optane (most people can't even notice NVMe vs. SATA).
Typical database load is an example of big queue depths. You have dozens of queries executing simultaneously and you're interested in throughput. So Samsung SSD is fine there (and raids are even better), unless your database is not typical and serves only a single client with low latency requirement.