Depending on the application, the difference in speed is in the range of 0% - 4%. See
this article ("As for using DDR500 SDRAM in the synchronous mode during FSB overclocking to 250MHz, we really doubt that it makes sense. This overclocker memory is much more expensive than ordinary DDR400 SDRAM, while the performance it provides is just a little higher than that of DDR400 SDRAM with 2-2-2-5 timings. The table below shows what difference between these two combinations exists in various applications.").
Per
this article, your first goal should be to max out your FSB. Then you worry about the RAM. Let's say you think you can get your bus to 275. It's unlikely you will find affordable memory with decent timings that will run at that rate. So, you will want to go to a 5:4 ratio, putting the memory at 220. That means you either want PC3500 (hoping it overclocks slightly), or PC3700. If you only intend to run your bus at 250, then the price of the PC4000 memory (not to mention the usually poor timings) probably won't be worth the marginal, if any, gain in speed you will get, and it would give you a better price/performance ratio to buy PC3200 memory with good timings. If you are talking about a P4 2.4C, though, you probably can get the bus higher than 250 and so you may want memory a bit faster than PC3200.