Will NVME SSD speed up heavy queries, e.g. selects at large offsets / table scans etc?

by Mary   Last Updated January 14, 2018 11:06 AM

If the database data will be on NVME SSD which let's assume is 4x faster than an ordinary SSD will queries like SELECT something OFFSET 100000 and the like typically also be much faster (of course when they are not cached/buffered etc)?



Related Questions




poor and/or unreliable InnoDB performance

Updated June 21, 2017 04:06 AM

How MySQL use the InnoDB Buffer?

Updated July 13, 2018 05:06 AM