This should provide a significant improvement on the processor side but you will still have an old machine and be out a few bucks. Your HD and video card will still be the same and these have improved as well since 2000. You did not say how much for the upgrade or what guarantee comes with it. As for myself, I'd suffer along and bank the money.
I have compaq 5bw220. It consists of a celeron 633 mhz, 512mb ram, onboard video and sound computer that I bought back in 2000. Money is short, so please no one suggest getting a new computer. I have contacted compaq customer support and they told me that I can upgrade up to a pentium 3 1.1mhz and 300watt power supply. How much do you guys think this will improve the performance of the computer.

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic