On Intel CPUs the memory speed doesn't make too much difference in overall application performance.
Pretty much DDR2-800 will be all you need, and DDR2-800 is the sweet spot for price/performance.
DDR2-1000 or DDR2-1066 costs a lot more for no real advantage.
The thing that DOES give you reason sometimes to buy those faster RAMs is to overclock the *CPU*.
The p35 and most other chipsets cannot have a RAM clock that is LESS than the CPU clock.
So if your CPU has a maximum x8 multiplier, say, and you want to get to 4000MHz on the CPU, that needs a base clock of 500 because 500x8=4000. Since a 500 MHz base clock going into the DDR2 would be actually the same as DDR2-1000 (since DDR2 doubles the clock) you'd need DDR2-1000 (PC2-8000) to be guaranteed to hit 500 MHz for both the RAM and CPU clocks.
The Q6600 = x9 maximum multiplier, and so with DDR2-800 (400 MHz stock rating guaranteed) RAM that'd be a 400 MHz RAM clock guaranteed and so 400 MHz would be the CPU base clock so 400x9=3600MHz max. overclock for the CPU without overclocking the RAM or buying faster RAM.
3600 is a decent overclock for a Q6600, so therefore 400 MHz RAM is a decent choice for the Q6600. Not everyone gets to 3600 on a Q6600, and to do so you'd need a high end heatsink and relatively expensive motherboard with heatpipe cooling for the PWMs and Northbridge etc. etc. so it starts to cost more money for RAM and heatsink and motherboard to really go beyond that and it is not at all guaranteed your CPU would even go to that point much less beyond it.
Even if you had all the right hardware and 500 MHz PC2-8000 RAM, it is seldom that you'd get a Q6600 to run past around 444Mhz (4000 MHz CPU), so really you'd probably be able to OC your decent DDR2-800 memory up to the max. the CPU/motherboard could handle anyway and thus not need PC2-8000 RAM to get the max. OC of the CPU.
If you bought today, and wanted PC2-6400 4GB (2x2GB kit) I'd get this:
http://www.newegg.com/Product/...x?Item=N82E16820220227
for $57 after a $20 rebate it is quite decent memory at a rock bottom price.
Patriot Extreme Performance 4GB(2 x 2GB) 240-Pin DDR2 SDRAM DDR2 800 (PC2 6400) Dual Channel Kit Desktop Memory Model PDC24G6400ELK - Retail
* Cas Latency: 5
* Features: Bladed aluminum heat shields to improve module stability RoHS Compliant EPP Ready
* Heat Spreader: Yes
* Recommend Use: High Performance or Gaming Memory
* Model #: PDC24G6400ELK
* Item #: N82E16820220227
* Return Policy: Memory (Modules, USB) Return Policy
5-5-5-12 timings @ 800 MHz.