topic Re: Paginated Report is too slow in Report Server

Paginated Report is too slow

Migasuke — Thu, 13 Apr 2023 22:19:36 GMT

Hi community,

I am building paginated report. My goal is to have simple table with a few columns.
I have two options how to build my table:
1. I put all fields from one table (fact table)
2. I put some fields from fact table and some from dim table.

I would prefer option 2, since I don't want to keep redundant data in my fact table.

Problem is, the moment I use parameters from dim table, speed decreases extremely.

In my scenario I have 1:N relationship.

Any tips how to optimize Parameters / Filtering in Paginated reports?

Re: Paginated Report is too slow

Medina — Wed, 26 Apr 2023 04:44:21 GMT

Hi Migasuke,

Without knowing more detail, I would recommend

Create a view on top of your fact table and join it with the dim table or tables.
Create a stored procedure that uses the view you just created with the parameter you need to filter the dataset.

And give it a try. Also, check the server where the Reporting Services is installed, for any memory pressure, etc. Some time ago, we experienced performance issues, and the network card on the server was the source of the issue.

Thanks!