0

I am using the ReportExecutionService object to call reporting services reports using the Render method. I am calling the web service multiple times from a Windows service call, loading multiple reports with multiple parameters.

Everything is working fine, but I want to know if:

  1. Is there a way to increase the process performance by reusing the SessionId obtained from the rs.ExecutionHeaderValue.ExecutionID property?
  2. If the answer to the first question is "yes": how do I reuse the SessionId on the calls?
Jeroen
  • 60,696
  • 40
  • 206
  • 339
Ricardo Huertas
  • 1,296
  • 1
  • 14
  • 15

1 Answers1

0

Interesting question and I will offer you two points of what I have found out in my fights with the SSRS server across multiple platforms and environments:

  1. The greatest problem in speed with SSRS seems to come from the service itself recycling itself every 12 hours I believe on 2008 and 2012. Not sure of prior to that. What I have done is create 'keep alive' service calls that just go to the root of http:// (servername)/ReportServer and ping it to keep it alive. It tends to go slow if it has not had activity in over that amount of time.

  2. I know that if you are adventuresome and you know .NET you can try to see if you can generate the report or report(s) multiple times. Basically the process to use C# you call the web service of SSRS directly in code(I make a proxy class to do this) and then you load the report up to the service, the parameters, then render it. You may be able when you instill an instance of that to load it multiple times. I never have tried it, but rendering reports directly from the proxy is surprisingly fast in the few instances I have tried it.

There is a session ID in this method but I am not certain is the session is kept to the report render or the invoke of the server. I would guess the report render but I have never tested this as I generally invoke my method for creations one at a time and they have been fast enough for my specifications.

Here is a link for #2 if you are interested: Programmatically Export SSRS report from sharepoint using ReportService2010.asmx

Community
  • 1
  • 1
djangojazz
  • 14,131
  • 10
  • 56
  • 94