Not so much. There are three major components that greatly factor into your machine's overall speed, the processor, the memory and the graphics card. But after a point, you hit a plateau, which means you are getting excessive.

Example:
256mb to 512mb = night and day
1GB to 2GB = not so much