How to improve performance of SSRS

Posted by Nishithraj under Regular Expressions on 2/22/2010 | Views : 3601 | Status : [Member] | Replies : 4

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

How to improve performance of SSRS report which is configured to an asp.net application. I have already cached the report.

It's having huge amount of data and the time taking to load in a page is very high. Any suggestions?

Mark this as answer, if it is.....

With regards
Nishithraj Narayanan

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Abhijit Jana on: 2/22/2010 [Member] [MVP] Bronze

0	The best way to improve performance is Caching, that you already implemented. Next thing that I can suggested you, don't load bulk amount of data to show the result. Use Filter show as minimum as possible data. Give user to select filter criteria and based on that show the data. Hope this will help you. Let me know if you have any more concern. Cheers ! Abhijit Nishithraj, if this helps please login to Mark As Answer. \| Alert Moderator

The best way to improve performance is Caching, that you already implemented. Next thing that I can suggested you, don't load bulk amount of data to show the result. Use Filter show as minimum as possible data. Give user to select filter criteria and based on that show the data.

Hope this will help you. Let me know if you have any more concern.

Cheers !
Abhijit

Nishithraj, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Abhi2434 on: 2/22/2010 [Member] [Microsoft_MVP] [MVP] Silver

0	Are you sure the table scan is not taking long time? Check if you have proper Indexes created for the table. Sometimes, creating a number of required Non-clustered indexes makes the database respond more quickly than ever. www.abhisheksur.com Nishithraj, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Nishithraj on: 2/24/2010 [Member] Bronze

0	Same data is not taking that much of time in ordinary gridview. Mark this as answer, if it is..... With regards Nishithraj Narayanan Nishithraj, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Abhi2434 on: 2/24/2010 [Member] [Microsoft_MVP] [MVP] Silver

0	Then it must be a problem on how you rendered your report. Check your report. www.abhisheksur.com Nishithraj, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts