SSRS使用HttpClientConnection对象性能问题下载PDF

问题描述

亲爱的，

Scnario：从报告服务器下载1000 PDF。

PDF大小：从30KB到250KB不等¥ b $ b业务要求：应在一个完成中完成小时

基础设施设置：报告服务器和sql作业，下载文件并存储所有内容都在SAME服务器中。

当前代码"



  Dim httpConn As ConnectionManager = Dts.Connections（" ReportServer"& strServer）

         Dim clientConn As HttpClientConnection = New HttpClientConnection（httpConn.AcquireConnection（Nothing））

        Dim docItemID As String = CType（Dts.Variables（" User :: DocItemID"）。Value，String）

        Dim ReportFileName As String = CType（Dts.Variables（" User :: FolderLocation"）。Value，String）& docItemID

        Dim TransportFee As Decimal = CType（Dts.Variables（" User :: TransportFee"）。Value，Decimal）

        clientConn.ServerURL =" http：// XXXX" &安培; strServer& " /的ReportServer / XXXX-报告/" &安培; strString& "&安培; docItemId = QUOT; &安培; docItemID& "& type = 3& rs：Command = Render& rs：Format = PDF& rc：Toolbar = False" b
        clientConn.DownloadFile（ReportFileName&" .pdf"，True）





$




问题：即使服务器CPU使用率不高也意味着服务器不忙，一小时内只能下载300个文件。

可以你能建议我们有什么其他选择来处理这种情况吗？现在我们可以在一小时内下载1000 pdf。



我们是否应该增加CPU内核，或者你认为任何其他类都可以提供比HttpClientConnection更好的性能。



提前付款



$

解决方案

Dear all,

Scnario : Download 1000 PDF from report server.
PDF Size : varies from 30KB to 250KB
Business Requirement: Shall be completed in one  hour
Infrastructure Setup: report server and the sql Job that downloads the files and store everything are in SAME server.
Current Code"

 Dim httpConn As ConnectionManager = Dts.Connections("ReportServer " & strServer)
        Dim clientConn As HttpClientConnection = New HttpClientConnection(httpConn.AcquireConnection(Nothing))
        Dim docItemID As String = CType(Dts.Variables("User::DocItemID").Value, String)
        Dim ReportFileName As String = CType(Dts.Variables("User::FolderLocation").Value, String) & docItemID
        Dim TransportFee As Decimal = CType(Dts.Variables("User::TransportFee").Value, Decimal)
        clientConn.ServerURL = "http://XXXX" & strServer & "/ReportServer?/XXXX-Reports/" & strString & "&docItemId=" & docItemID & "&type=3&rs:Command=Render&rs:Format=PDF&rc:Toolbar=False"
        clientConn.DownloadFile(ReportFileName & ".pdf", True)





Problem: Even if server CPU usage is not much that means server is not busy, still in one hour only 300 files are getting downloaded.
Can you please suggest what other options we have to handle this situation? Now can we download 1000 pdf in one hour.

Shall we increase the CPU core or do you think any other class can give better performance than HttpClientConnection.

Thanks in advance

解决方案

这篇关于SSRS使用HttpClientConnection对象性能问题下载PDF的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！