Data Warehouse Results

This test is different than our other tests as there are no parallel queries being executed. On the other hand, the query optimizer is able to use parallel execution and utilize multiple processors for the same query. This does not lead to the same CPU load as parallel queries, but does demonstrate a measurable difference in execution time.

In these tests, the datasets are mostly 100,000+ records and are many times larger than the L2 and L3 cache; thus, the additional cache is of no benefit. It is all about the number of instructions that can be completed in a given period. The ability to move data quickly in and out of the CPU are the characteristics of a winner in this test.
  • There is a 30% spread in results between the fastest and slowest platform. Yet again, it is proof that you do not have to be CPU bound to recognize a performance gain from a hardware upgrade.
  • The Dual Opteron 252's lead by 19% over the closest Xeon, which was the Quad Xeon 3.6 GHz 667MHz FSB
  • The Quad Xeon 3.6 GHz 667MHz outperformed the Dual 3.6GHz 800MHz FSB by 8%.

Datawarehouse Test

Data Warehouse Results Dual Core Desktop Performance: AMD’s Athlon 64 X2 4400+
Comments Locked

144 Comments

View All Comments

  • StrangerGuy - Thursday, April 21, 2005 - link

    I find it strange why AMD did not release <2.2GHz A64 X2s? Maybe due to manufacturing issues?
  • LX - Thursday, April 21, 2005 - link

    How will the bandwidth limited X2 be affected by overclocking?
  • Chunkee - Thursday, April 21, 2005 - link

    Nicely done. The price will be a factor as usual. Does the performance gain justify the cost? For the enthusiast yes, but I will wait a bit. My 754 setup with a raptor still rocks plenty enough for me. The technology improvements are great. I will always be a big AMD Fan.

    jC
  • linkgoron - Thursday, April 21, 2005 - link

    not bad... but AMD should make <500$ athlon 64 X2 CPUS

Log in

Don't have an account? Sign up now