The fastest _specified_ memory standard is PC3200, aka DDR400, technically DDR SDRAM at 200 MHz. This also happens to be what any incarnation of the AMD64 architecture likes best - although you can feed it any lower speed DDR RAM as well. E.g. when you migrate a twin set of slower DIMMs to an AMD64 machine, it'll be much less of a brake to the new system if it's a dual channel configuration.
Socket 939 and 754 take the commodity type "unbuffered" DIMMs, while socket-940 wants server grade "Registered" or even "Registered ECC".