I work for a software company. When we sign new clients, the old software supplier makes a 'dump' of their database that we can then import. However, 99 out of 100 times we manually have to do a lot of things with these dumps to make them compatible with our software.
Since these dumps can be pretty large (the sheet itself can be up to 500mb - 1gb) and contain 100's of thousands or millions of records), we need a really good PC that can handle this well. When we open one dump, it can take up to 30 seconds. When we save some of the changes we've made, it can also take somewhere between 10 - 30 seconds.
FYI, the PC we're doing this on right now has these specs
- Gigabyte GeForce RTX 3060 EAGLE OC 12G 2.0
- AMD Ryzen 5 5600X
- Crucial P2 1TB M.2 PCIe Gen3 NVMe Internal SSD - Up to 2400MB/s - CT1000P2SSD8
- Crucial Ballistix BL2K8G36C16U4B 3600 MHz, DDR4, DRAM, Desktop Gaming Memory Kit, 32 GB (8 GB x4), CL16
- I am not sure about the motherboard, but we need WiFi :)
I basically need a PC with a really good SSD, Processor and RAM. There won't be any gaming, so a really simple or cheap GPU will be just fine.
What are your hardware recommendations?
BTW: not looking for an upgrade. We need a new build anyway.