A vage reference like Support Intel® next generation 45nm Multi-core CPU is often made because the manufacturer want to indicate that future, as yet unreleased CPU's of that category should work. Sometimes this also requires a BIOS update.
First check which CPUs are supported. From the link you gave: I see the
- Intel Socket 775 Pentium® 4 Processors (Old, slow, hot)
- Intel Socket 775 Pentium® D (two old slow hot P4s on a chip)
- Intel Socket 775 Pentium® Extreme (same old hot, but faster and more expensive)
- Intel Socket 775 Core™2 Duo (core2 design. Faster and much less power used)
- Intel Socket 775 Core™2 Quad (core2 design. 4 CPU cores)
- Intel Socket 775 Core™2 Extreme
You want a core2 based CPU.
Next look t the available socket 775 CPU core2 CPUs: Wikipedia has a long list of core2(tm) CPUs.
If you want the fastest single traded performance go for a chip with a high clock speed. If you want max performance go for a chip with the most cores. If you can combine those two then that is great, but often you will have to choose between higher rated but fewer cores parts or a part with more cores. (More MHz and more cores usually mean more heat, thus the combination of those two is usually limited).
The fastest duo core is the Core2 due E8600 with 2 cores at 3.33Ghz and a TDP of 65 Watt.
The fastest quad core is the Core2 quad 9650 with 4 cores at 3Ghz and a TDP of 95 Watt.
With only 10% difference in clock speed and double the cores I would to for the 9650.
Next, check that:
- Check that your motherboard can supply up to 95 Watt
- Check that your CPU cooling can move 95 Watt away from the CPU.
- Check that your BIOS supports it. If it is supported by a newer BIOS than update this before replacing the CPU.