I have been doing some benchmarking between the 32 and 64 bit versions of QV, and have found a significant discrepancy in performance for a Pivot Table calc times, which I think may force us to use the 32 bit server if a better solution cannot be found. I am running QV 9 SR3 Build 7440
I suspect that we're doing something funky that most other QV users aren't doing (i.e. large expressions with conditional logic containing set expressions. Interestingly I've separately tested with two different expressions: one dealing with averages (i.e. floating point operations) and the second with only counts and sums (i.e. integer operations).
I should also point out that until SR3 came out, this code didn't work at all in the 64 bit version, so I wonder if my suboptimal performance is related to this patched bug.
I've pasted the Pivot Table dimension definitions below (the first 5 dimensions are primary [i.e. rows], and the 6th dimension is secondary [i.e. columns]).