Wow this is a great topic and I have been wondering about a lot of this as well.
So how does memory speed effect all this GHz speed. Cause it used to be high memory speed with tighter timings and now it seems they change to higher memory speed but with super slow timings.
Timings are not actually super slow.
Most people remembering this are thinking back to original A64 days when PC3200 / DDR400 was around. These were often CAS3, but tight timings were CAS2 and this made a big difference.
Latency is measured in number of clock cycles, which is really difficult to make comparisons at different memory speeds. So we should convert timings to units of time, which can easily be directly compared. DDR400 runs at 200 MHz (which is 1/time) So CAS 2 uses 2 of these clock cycles, which takes 2/200 MHz seconds (10 ns). If 2 cycles is 10 ns, then CAS 3 latency is obviously 15 ns.
Take a modern memory with "super slow timings" Say a DDR3 2400 kit. These come in CAS 11 and some are low latency CAS 10. To compare to DDR 400, we convert these to units of time:
CAS 11 = 11 / 1200 MHz = 9.16 ns
CAS 10 = 10 / 1200 MHz = 8.33 ns
So these "super slow timings" of 10 and 11 clock cycles are actually tighter than the "tight timings" of yesterday since clock cycles are 6 times faster than they were then, but number of cycles is less than 6 times higher. In other words, you need to ratio the latency to the memory speed in order to compare across different memory speeds.
In general, memory frequency rises over time with new products and process refinement, but latency changes are much less dramatic. It is a common misconception that latency is worse, but that's only because the units used are not able to be compared directly unless you're comparing kits running at the same speed.