the thins is that i cant afford a new one but at least a want to see this one rip it til the end,and i read somewhere that this cpu was the limit on abit nf7 but if you say that there is a better one i would like to hear your suggestion and i would pay whatever it costs for cpu and graphics card
Just make sure your CPU fits the motherboard socket. Look into that.
Yeah, shadows right on that one
Anyway, just about any modern DX10 AGP GPU would be a huge upgrade for you. Personally I think it's about two years too late to invest anymore into your system if you plan to game since your CPU will disqualify you from even trying to play many newer games, or at least play them at any semi-reasonable setting. Anyway I say a good match for you would be a Radeon 3650 AGP. You may want to go with a 3850 if you're playing games at a resolution greater than 1680x1050, but because of your CPU being the bottleneck even then the benefit over a 3650 generally won't be that great.
If you're going with a 3650 AGP make sure you have a decent PSU of at least 350W. If you choose to go for the more power hungry 3850 AGP then go for at least a 450W PSU, but I would recommend a good and stable 500W (or 450W high quality) PSU so you can overclock. That old XP 3200 will overclock better if the PSU delivers nice stable power.