Reply 20 of 24, by Blzut3
In regards to TRIM, I want to add that as someone that maintains racks of servers with SSDs, we don't have TRIM enabled on any of them. Pretty sure the RAID controller can't even pass through TRIM. Now consider that these servers are reading and writing data constantly 24/7 and we've have had orders of magnitude less failures than HDDs and I think retro systems will be absolutely fine.
I'm not saying that one shouldn't enable TRIM if it's available since it will allow more free pages to be ready should they be needed, but all SSDs these days should be over provisioned such that one shouldn't really see much of a perf difference regardless of TRIM or not. Modern drives are constantly remapping pages for wear leveling and performance. In the days when SSDs were 32GB I don't know how much if at all they over provisioned, since I do know that it is part of the reason SSDs generally stopped being exact powers of two.
I would recommend a real SSD over CF/SD cards since the latter is usually made out of the cheapest flash and probably doesn't have the aforementioned over provisioning. That said it really does depend on the use case for the machine. If the machine is used infrequently, which I would assume is the case for most retro systems, or can take advantage of being able to easily swap cards/images then they're a fine option.