Any advice for development hardware for MySQL 8, innoDB, windows, with complex queries?
It's time to replace my laptop and I'd sure appreciate insight.
I'd like to stick with Windows because I know it and will use the same computer for office-type tasks. I like using a laptop because I grew weary of replacing battery packs for backup power. I've been happy with Dell Precision laptops, but which processor, how much RAM, SSD...?
I often wait a long time for processes to complete. More speed is desired. My existing laptop is an i7, 3 Ghz, 4 cores, 16GB RAM.
A guy at Dell who knows nothing about MySQL, suggested:
Intel Xeon Processor W-11855M (6 Core, 18MB Cache, 3.20GHz to 4.90GHz, 45W, vPro)
64 GB, 4 x 16 GB, DDR4, 3200MHz, Non-ECC, SODIMM
M.2 2280 1 TB, Gen 4 PCIe x4 NVMe, Solid State Drive
Does that sound right? My database is 1.8GiB and will probably not grow much beyond 2 in the next couple years. Thanks if you read this far.