• 26 Posts
  • 1.3K Comments
Joined 2 years ago
cake
Cake day: June 20th, 2023

help-circle





  • You really have to see what the db is doing to understand where the bottlenecks are, i.e. find the query plans. It’s ok if it’s just single selects. Look for stuff like table scans that shouldn’t happen. How many queries per second are there? Remember that SSD’s have been a common thing for maybe 10 years. Before that it was HDD’s everywhere, and people still ran systems with very high throughput. They had much less ram then than now too.









  • Newegg doesn’t seem to sell the Crucial MX500 any more*, only the BX500. But if the 870 evo is comparable, I might get that, since I have a couple of MX500s now and am happy with them. I hadn’t realized that Team Group was legit at all! I’ll keep that in mind. Thanks!

    *Note: The MX500 appears on Newegg’s web site, but the actual sellers are “Newegg Marketplace” randos rather than Newegg itself, and I prefer to buy directly from Newegg when possible.







  • HMB is host memory buffer or something like that. It means instead of having a ram buffer in the drive, the OS software uses some of the host computer’s memory for disk buffering. That makes the drive cheaper but I haven’t heard claims of it being any faster. Consumer drives seem to all use it now, and Linux supports it, but maybe not when you wrap up the HMB drive in a SATA shell.

    I guess $90 for 1TB is pretty good. I have been suspicious of the EVO drives but at least they aren’t QVO.

    Thanks!