Prev: Microsoft Responds to the Evolution of Online Communities
Next: Using variables
From: peter feakins on 5 May 2010 12:56
We have large multi-select list box (8000 items). When we run the report in
visual studio (database is on separate server) the select box loads very
quickly and
when we click view report it renderes quickly ( both wothin a few seconds).

When we deployed the report to the reporting services server and attempt to
execute the report the remotely we have performance issues. The initial
loading of the combo box takes over a minute and then the rendering after the
report is executed will take close to 2 minutes. The queries themselves run
very quickly. Other reports without the large multi-select execute very
quickly.

What accounts for the difference in performance between the two environments?

--
peter feakins
From: Bruce L-C [MVP] on 5 May 2010 12:58
What version of RS?

The 8000 item list, is it filled with a query or stored procedure?

Seems unreasonable to have users scroll 8000 items. Have you considered
cascading parameters?

--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

"peter feakins" <peterfeakins(a)discussions.microsoft.com> wrote in message
news:9E90668C-FA68-4440-B487-B213F2BEF744(a)microsoft.com...
> We have large multi-select list box (8000 items). When we run the report
> in
> visual studio (database is on separate server) the select box loads very
> quickly and
> when we click view report it renderes quickly ( both wothin a few
> seconds).
>
> When we deployed the report to the reporting services server and attempt
> to
> execute the report the remotely we have performance issues. The initial
> loading of the combo box takes over a minute and then the rendering after
> the
> report is executed will take close to 2 minutes. The queries themselves
> run
> very quickly. Other reports without the large multi-select execute very
> quickly.
>
> What accounts for the difference in performance between the two
> environments?
>
> --
> peter feakins

 | 
Pages: 1
Prev: Microsoft Responds to the Evolution of Online Communities
Next: Using variables