Forum Discussion

Migasuke's avatar
Migasuke
Icon for Memorable Member rankMemorable Member
3 years ago

Paginated Report is too slow

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?

 

 

@paginated report. @optimisations

1 Reply

  • Medina's avatar
    Medina
    Icon for Resolver I rankResolver I
    3 years ago

    Hi Migasuke,

    Without knowing more detail, I would recommend

    1. Create a view on top of your fact table and join it with the dim table or tables.
    2. 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!