posted on Wednesday, June 30, 2004 2:16 PM
by
thomasswilliams
Tips for Optimising Reporting Services Performance from tudortr
tudortr has some tips on measuring and improving Reporting Services performance. I heartily agree with number 1: optimise your queries. I've found that using a) proper indexes and b) creating intermediate tables where necessary (possibly containing summarised data from a month that is reported in many different reports, rather than going to the transaction-level original data table, for instance) are the best things I can do to improve performance on my reports.