What Video Card would be best for my CPU with no Bottlenecking

It wont matter if it bottlenecks or not, Ill say it again, the single most benefit a gamer gets out of upgrading is the graphics card. Period. You may bottleneck your card with that cpu, but getting 20 fps with a 7900gtx vs 35 with a 8800gt even bottlenecked is the question you need to ask yourself. Sure, if you had a 3.6 GHZ QCD you may get 45 FPS, but 35 is STILL better than 25

Oh thanks guys .. should I then OC it from 2.0 to 2.5 for any benefit
Thanks for the quick reply guys much faster than other forums.

Ok I guess I am going 8800GT if I can find it in stock - Thanks for the answers.

Your CPU would be fine with the 8800GT. Sure you may bottleneck the card a bit, but it's very unlikely it's anything you'd actually notice. CPU bottlenecks are generally only observed at low resolutions with low graphics settings.

Wait so ^ so you upgraded from a 7900 to a 8800 with no gains? Wow I am getting some mixed opinions ... anyone with a 939 board confirm this.. I am not planing to upgrade till I graduate in 2 years since I bot 4gb of ram

This statement is right and wrong. It goes both ways. Let me explain how I understand it:

A higher end card can give you more Frames Per Second @ higher resolutions then a lower end card. This does not mean you'll be getting 50 FPS @ 1280x1024 and magically receive 90 FPS @ 1600xWhatever resolution. It just means that the GPU has higher processing power than it's predecessor at higher resolutions.

Let's say as an example (both rigs we'll assume are using the same hardware besides the GPU):

7900 runs @ 1280x1024 w/ 50 FPS
@ 1600x1250 w/ 25 FPS (50% loss because it's relying more on the GPU)

8800 runs @ 1280x1024 w/ 70 FPS
@ 1600x1250 w/ 68 FPS (A very small % drop because the GPU is more powerful)

All in all, your CPU is not going to make you frame rates at a lower resolution less than they would be at a higher resolution. You'll just see less of a performance drop when moving to higher resolutions.

A bottlenecked video card simple means you're getting the absolute most out of your processor. At the current price for an 8800GT, I'd say it's well worth it.

I'm using a socket 939 4400+ X2 2.2Ghz and was previously running a 7800GT card, but with my new 2900Pro I have seen huge gains in performance.

You clearly do not understand what you're talking about.
Celeron has NEVER been dual core (but they will in 2008 with the E1000 series). Netburst and Athlon 64 architectural differences are what you're seeing (not this true-dual-core you're talking about). Yes, Pentium D processors weren't great, but their shortcomings were not caused by the two-processors-in-one-package design. This was caused by the horribly long pipeline in the Netburst architecture (among other things). Look up instructions-per-clock and you'll understand why the Pentium Ds were lacking compared to the X2s.

You are correct, I remember that post that a stupid salesman told a guy the Celeron 420 was a dual core chip (which it's not). Where it can be confusing is that Celeron D kinda sounds like Pentium D, and that would make one think it's a dual core part (which it's not). The Celeron based on the Conroe-L (420, 430, & 440) is based on Core architecture. The Pentium M also has a cheaper variant called the Celeron M (both of which are based off of Pentium 3 architecture [I know it's not a P3, don't flame me]), both of which are single core. The Core Duo you refer to is indeed based on the Pentium M architecture (and is dual core). So as you can see, naming schemes are impossibly hard (and even harder to keep up with).

Sorry to jump on your case, I just wanted correct information given. And apologies to kbhadauria for the post highjack.

Edit: Core-based Celeron Ms were also made under the names 520, 523, 530, 540, & 550.

GPU vs. cpu is a little complicated.
http://www.anandtech.com/cpuchipse [...] i=2747&p=4

For the MOST part, the gpu will increase the speed more then upgrading the cpu. In certain games however, the cpu will show a very good performance increase, like MS flight simulator, but others will show no or little improvement with a newer cpu (most games NOT limited by cpu).
Wish I could find the article that showed it perfectly, but i can no longer remember where i saw it at.

Thanks for all your help guys.... For those in Canada I found a 8800Gt and got it at 259xx
http://www.futureshop.ca/catalog/p [...] 590&catid=
Price has gone up .. but I think if you go to the store they well match last nights cost..

Thanks again.