Hi,
I have a SQL2005 report that has 3 multi-value parameters, one of these has
14,000 values, the other 2 have less than 600. The queries to populate these
lists each take less than a second to run.
While previewing these report in the dev environment they load fairly
quickly (20 seconds) and the report renders with ease. However, when I run it
through the Report Server it takes ages to load the parameters (like 5 mins)
then a further 5 mins to render the report.
IE (version 6) seems to battle with loading the multi-value controls. It
starts hogging the CPU, using up memory and knocking up the I/O Reads and
writes. Both on loading the parameters and rendering the report.
Any suggestions on getting IE (or is it IIS) to handle this load ?
Thanks,
Claude