I’ve never dealt with MySQL before, so I am very new at this.
I am connecting my MS Access front-end to MySQL server. The server configuration is 2 CPU Cores, 2GB RAM and 60GB SSD. The server has over 200k records, which I and my team will need to look at daily and import more records daily.
Will this be fast enough for 3 people connected to it simultaneously, or should I upgrade the server?