If you were to get a 8800GTS/X your 3200+ would be hard pressed to keep up with it. That would have been the bottleneck. The next gen video cards like the 8800 series require a fast dual core cpu to get the most out of them.
The 3200+ will be fine paired with the 7900GS though.