Will it make sense if I get a great graphics card but keep my average CPU?

Hi I'm planning an upgrade of my PC to play new games like bioshock & call of duty 4. I currently have a P4 3.2 ghz processor and a geforce 6600. I want to play these games at a reasonably high resolution and am upgrading my graphics card to something in the geforce 8800s series. What I want to know is are... show more Hi I'm planning an upgrade of my PC to play new games like bioshock & call of duty 4. I currently have a P4 3.2 ghz processor and a geforce 6600. I want to play these games at a reasonably high resolution and am upgrading my graphics card to something in the geforce 8800s series.

What I want to know is are my proccesor and graphics card linked? Will I take full advantage of a geforce 8800 GT with my current processor or will I have to upgrade that as well?

Thanks.
Update: Oh and my RAM is 2 gb.
4 answers 4