Toad World® Forums

Most important thing for TPC-H


#1

of spindles = more disks = better response time per query

see my blog at - issue #5 - at:

http://www.quest-pipelines.com/pipelines/ExpertFiles/Top5DBBenchmarking.pdf


#2

I forgot to mention, don’t be surpsied if you have under 100 spindles and 300GB+ database if the run time is several hours or worse. TPC-H stresses IO system to the max - mostly # spindles working on shared problem - but also the cache and caching algorithms in your hardware. My point - cannot run a real TPC-H on a notebook, desktop, or even older server that’s been retired from service :slight_smile: