Toad World® Forums

Most important thing for TPC-H


of spindles = more disks = better response time per query

see my blog at - issue #5 - at:


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: