The fastest available is DDR400, but I really don't think you'll see very much of a performance improvement. But if it's cheaper than the DDR333, then by all means grab it.
If you are running XP, a total of 2GB is about the sweet spot for good performance. For Vista, look for around 4GB of total system memory.