• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 553
  • Last Modified:

Reporting Services cache reports problem

We have a report that takes a very long time to run (no way to optimize) and the user cannot wait for it, so it must be cached.  My problem:  The data pull runs at :20 after, finishes at about :40.  The cache is flushed at say :50, but the cache takes a while to swap, say from :50 to :60.  Is there no way to trigger the swap after the cache is flushed?

Doesn't the user run the risk of opening the report and having to wait: (:45 - :60)  It doesn't make sense (for me) to have the cache flushed, then swapped.  Am I missing something?

FYI I use a subscription to swap the cache for 12 different parameter values (languages).  The reports display an unual amount of text, thus the length.

Any help appreciated,

  • 2
1 Solution
How many parameters are on report. Is it just the language or are there 12 differnet parameter inputs?
billinbAuthor Commented:
There are four other parameters other than language in report, but they go to defaults.  The users don't care about the other four and know to export before changing them.   As example, one parameter is test section, multi-select, and the default is the entire dataset.  So there are 12 different parameter combinations stored in cache.

There is a data driven subscription that runs the 12 values for language, so there are 12 runs in cache.
The data driver table is just a one column list of the languageID's, i.e. 1033, 1036, 3084 etc.  So yes, there are 12 parameter inputs for language.  Does that answer your question?
billinbAuthor Commented:
If anyone wants to take a stab at it, that would be fine.  I'd like to close this out pretty soon.

The question is fairly vague.  Basically I'm stuck with this huge report with huge text fields.  The user would have to wait a fairly long time, unless the report was cached.  The data updates throughout the day.  If there were 15 minutes out of each hour that the report wasn't cached, the users would hit on it frequently (Murphy's Law)

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now