Explain the key differences in execution speed, memory management, and use cases between C and Python.