sdram is the slowest of all the memory technologies.
DDR would be better to get on the P4, but the highest performing solution ramains to be RDRAm for the P4 for now. It is also the most expensive option.
Go to the front page of anandtech and read the reviews on chipsets for the P4. You find all the info you'll need