Indexing with a NVMe PCIe Mini SSD?

"Reed Crosby

@reedcrosby


Rep: 3.9k




19


19


22"

"The Indexing you are speaking about is really useful for a server or cache server which is storing web pages. It's not very useful for a client system.

As for using a SSD to store them (it makes no difference what the I/O is) the churn of the data is what will wear the SSD. So if the the web pages are static in nature or change lets say daily the amount of change is not that heavy. Its if you were to monitor something like the stock market which has trades going every 10 sec's or so that the churn would wear the drive. Even still the number of stocks would need to be quite high as well.

Now lets look at a shared database (DB2/SQL/Sybase) used in a store which manages large quantities of goods then the index would help keep the counts correct to the second. Some of these DB's do their own indexing and some may even use the MS developer code to setup the index function."