Thread of PC Woes, Troubles, Problems, and Issues

[BeoTeK]

At home my SSD has my OS and 1 game on it. I put the game on there because it kind suffers from long-ish loading times and the SSD helps. At work my laptop only has an SSD so everything is installed on it. IMO, i would use an SSD to only run the OS and perhaps 1 or 2 regularly used apps.

So you wouldn't recommend it to run database(s) on?

[PsychoFish]

A question if I may; SSD drives have a read/write life cycle, as such this is somewhat of a double edged sword. Do you put applications or operating systems that get used very often but you'll benefit from it's speed improvements, or do you load applications or data intensive applications or function on them that you may not use as often but benefitted greatly from it's speed improvements?

SSD wear is on write. It's a bit of a double edged sword as you mentioned. Effectively you want the stuff you want to LOAD quickly on the SSD and you want to minimize unnecessary writes to the SSD.

NEVER EVER put your swap file on your SSD. Yes it's fast, but it will severely shorten the life of your SSD with useless writes.

[PsychoFish]

So you wouldn't recommend it to run database(s) on?

if you use Enterprise grade MLC and TLC drives then a DB is perfectly fine...

but then again you're forking out R45k per 3.75 TB drive

[BeoTeK]

if you use Enterprise grade MLC and TLC drives then a DB is perfectly fine...

but then again you're forking out R45k per 3.75 TB drive

But even consumer grade SSD's, running a database(s) on this drive will surely improve its overall performance in reading and writing to the DB but this will result in much shorter lifespans of the drive, isn't?

[PsychoFish]

But even consumer grade SSD's, running a database(s) on this drive will surely improve its overall performance in reading and writing to the DB but this will result in much shorter lifespans of the drive, isn't?

100% correct...just don't expect the drive to last very long. After ~100TB worth of writes most consumer grade SSDs will start reallocating, and once that start happening it's on its way out.