I've have a python program and 500GB SQL database related to that. My main hard drive is getting too small and therefore I'm looking for an external one. However I do not have much experience with external drives.
To get the maximum performance:
Should I install Python into the external drive? Should I store the Python program into the external drive?
Does it affect on performance if the OS (Windows) is located in main drive - not the drive that stores the Python program and the database?
What should I keep in mind when buing the external drive (probably gonna go with USB3.0/SSD)?