I tested Win7 RC on a P4 (540J) with 1gb of RAM and it ran equal or better than XP on it, unlike Vista.
Personally, I would not waste money upgrading an XP box to Win7. You can't upgrade the RAM on that PC to take advantage of 64-bit OS's, and there isn't anything that will run on 7 but won't...