I am a "developer" that writes exclusively VBA scripts and applications. Usually, the application is very fast. However, when I utilize "Update" commands that are a combination of opening/closing files, transfering data, manipulating data, the occasional SQL query, and a smorgasbord of random VBA Scripts. Almost always, the code is in MS Excel.
I understand that if my code is inefficient, it will slow performance. I understand that if my SQL Query is inefficient or the database from which I am pulling it is not indexed properly, it will slow performance.
Other than that, what kind of PC improvements would cut down on the run-time / increase performence? An SSD? A faster processor? More RAM? I didn't see much improvement from having 16 GB of RAM.