Subj : Re: hyperthreading in database-benchmarks
To   : comp.arch,comp.programming.threads
From : Del Cecchi
Date : Mon Oct 10 2005 11:30 pm


"Oliver S." <Follow.Me@gmx.net> wrote in message 
news:434b25a3$0$64081$892e7fe2@authen.white.readfreenews.net...
> Has anyone found information on how much hyperthreading is able to 
> improve the
> performance of database-workloads (OTP as well as DWH)? As far as I 
> know, data-
> base systems have a un-usually high rate of cache misses and though 
> suffer more
> the latency-"problem" of current memory-subsystems. So I guess, 
> databases will
> profit more from hyperthreading than most other appications.
>
> And to get some synthetic numbers on how hyperthreading is able to 
> partitially
> compensate the latency-problem, it would make sense to run a 
> memory-latency
> (with the usual pointer-chasing method) benchmark with two thrads; has 
> anyone
> found some numbers on this?
You could look in the power5 issue I referenced in another thread.  I 
recall an article about hyperthreading.

.