You have to create your database without any indexes, then you can add them later for a speed boost
You have to create your database without any indexes, then you can add them later for a speed boost
I’ve heard you are supposed to stop by 150
A lot of people start on used small form factor desktops like the ASUS PS52. Other common ones are the Lenovo M series tiny desktops, Dell Optiplex micro desktops or Intel NUCs. These can sometimes be found used for sub $100 a piece from businesses updating their fleets. They can struggle a bit doing stuff that needs some CPU grunt, like live plex transcoding, but are decent otherwise, especially considering the low power draw. You might want to consider spreading that software demand over two or three of them.
I started one on Linode, a 2gb shared vps. Seems to be running fine so far. Cost per month is $12.
My understanding is that as the amount and speed of memory increases, the usefulness of ECC in detecting and preventing the types of errors that can cause a crash or corrupt a file goes up.
But for home use it’s probably more useful to focus on storage redundancy and backups, or a UPS to keep things running during power blips/outages.
This is the big reason. I keep the boxes to make future moves easy, learned the lesson the hard way.
Other good reasons are the box keeps all the accessories in one place while saying what they are for (psu boxes, looking at you) or the box is great at storing that type of item, like the box my NAS drives came in, perfect foam insert for other drives