Qfyilyi

I'm rendering a SQL server reporting services report through the web service, using the following code:

    LoadReportRequest req = new LoadReportRequest(new TrustedUserHeader(), "Report", null);

    LoadReportResponse report = await _reportingClient.LoadReportAsync(req);

    ParameterValue parameters =

    {

        new ParameterValue { Name = "Id", Value = labelId.ToString() }

    };

    SetExecutionParameters3Request pReq = new SetExecutionParameters3Request(report.ExecutionHeader, new TrustedUserHeader(),parameters, "en-us");



await _reportingClient.SetExecutionParameters3Async(pReq);

RenderRequest rReq = new enderRequest(report.ExecutionHeader, new TrustedUserHeader(), "PDF", null);

    var response = await reportingClient.RenderAsync(rReq);

I'm getting the following time measurements:

• Load report: 13s


• Set execution parameters: 8s


• Render report: 14s

Altogether a staggering 35s for a quite simple report, ca 20 fields all read from a single table.
Looking in the execution log in SSRS, it says that the total time for rendering the report is about 6s.

Rendering the report through the SSRS web portal is very fast.

What could be the problem here?