中继器响应时间的改善 [英] Repeater esponce time improvement

问题描述

大家好，

我有转发器，大约需要20秒才能渲染5k记录。是否有可能改善响应时间。没有分页。



我的sql查询花了将近1秒来选择所有记录。



请建议合适解决方案。

Thnaks

Hi All,
I have repeater which taking around ~20 seconds to render 5k records. Is there any possibility to improve responce time. No Paging.

My sql query taking almost 1 second to select all records.

Kindly suggest appropriate solutions.
Thnaks

推荐答案

谢谢Andy的回复!!



我有简单的中继器，有7列。在服务器端，我通过DataTable直接获取数据。客户希望对整个数据进行排序，因此分页将适用于整个数据。



我认为转发器在渲染大量数据时需要时间。



有什么解决方案可以改善时间。





< asp：repeater id =rptLocationListrunat =serveronitemcommand =rptLocationList_ItemCommandxmlns：asp =＃unknown>

< headertemplate>





< th style =width：15％>< asp：linkbutton id =lnkLastModifiedByrunat =servercommandname =LastModifiedBy>

CssClass =hrefclass> Last Modified By

< asp：linkbutton id =lnkFieldNamerunat =servercommandname =FieldName>文件名	< asp：linkbutton id =lnkStatusrunat =servercommandname =Status>状态	< asp：linkbutton id =lnkLastModifiedDaterunat =servercommandname =LastModifiedDate>上次修改日期	< asp：linkbutton id =lnkAvgYieldrunat =servercommandname =AvgYieldcssclass =hrefclass>平均收益率	< asp：linkbutton id =lnkOilOrNDFDrunat =servercommandname =OilOrNDFDcssclass =hrefclass>油％或NDFD

< itemtemplate>

< asp：hyperlink id =LinkStoryfont-bold = truefont-underline =falseforecolor =Blue>

Style =white-space：nowrap; runat =serverNavigateUrl ='<％＃Eval（FieldName，〜\ ViewLocationDetails.aspx？LocationName = {0}）。替换（＃， - hash - ）％>'

Text ='<％＃Eval（FieldName）％>'>

< asp：hyperlink id =LinkConflictsfont-underline = falseenabled =<％＃Eval（statuslinkenable）=％& gt;=>

runat =server字体粗体='<％ #Eval（StatusFontBold）％>'ForeColor ='<％＃System.Drawing.ColorTranslator.FromHtml（Eval（StatusForeColor）。ToString（））％>'

NavigateUrl ='<％＃Eval（FieldName，〜\ ManageageConflicts.aspx？LocationName = {0}）。替换（＃， - hash - ）％>'

Text ='<％＃Bind（Status）％>'ToolTip ='<％＃Ev al（StatusLinkToolTip）％>'>

<％＃DataBinder.Eval（Container.DataItem，LastModifiedDate，{0：MM / dd / yyyy}）％> ;

< asp：label runat =servertext =<％＃Eval（lastmodifiedby）=％& gt;=style =white-space ：nowrap;>

<％＃DataBinder.Eval（Container.DataItem，AvgYield）％>

<％＃DataBinder.Eval（Container .DataItem，OilOrNDFD）％>

< asp：imagebutton id =btnVi ewcommandname =查看commandargument =<％＃Eval（fieldname）％& gt;=>

ImageUrl ='<％＃Eval（btnViewImageUrl ）％>'启用='<％＃Eval（btnViewEnable）％>'

runat =server工具提示=查看/打印位置详情报告OnClientClick =frmFTDMain .target ='_ blank'; document.location.href = document.location.href; />

< asp：button id =btnUploadcausevalidation =falsecommandname =Uploadrunat =server>

ToolTip =上传模板已启用='<％＃Eval（btnUploadEnable）％>'CssClass ='<％＃Eval（btnUploadCssClass）％>'

UseSubmitBehavior ='< ％＃Eval（btnUploadSubmitBehaviour）％>'OnClientClick ='<％＃String.Format（return openWinUpLoad（{0}，{1}，{2} ，{3}）;，Eval（FieldName），Eval（Crop），Eval（UserName），Eval（Status））％>'/>

< asp：button id =btnDownloadstyle =display：nonetext =Downloadcommandname =Download>

OnClientClick =免责声明（）CommandArgument ='<％＃Eval（FieldName）％>'runat =server/>



onclick =免责声明（'<％＃Eval（FieldName）。ToString（）。替换（'， - apostrophe - ）％>'）/>

< asp ：imagebutton id =btnSubmitimageurl =<％＃Eval（btnsubmitimageurl）％& gt;=runat =server>

OnClientClick ='<％ ＃String.Format（return OnSubmit（{0}，{1}）;，Eval（Crop），Eval（AvgYield））％>'

CommandName =提交已启用='<％＃Eval（btnSubmitEnable）％>'CommandArgument ='<％＃Eval（FieldName）％>'

ToolTip =提交模板/>

< asp：imagebutton id =btnDelimageurl =<％＃Eval（btndeleteimageurl）％& gt;=runat =server>

CommandName = Delete_FieldEnabled ='<％＃Eval（btnDeleteEnable）％>'CommandArgument ='<％＃Eval（FieldName）％>'

ToolTip =删除模板 OnClientClick ='<％＃String.Format（return ConfirmOnDelete（{0}）;，Eval（FieldName））％>'/>





< footertemplate>











和服务器端代码：



rptLocationList.D ataSource = dtLocations

rptLocationList.DataBind（）

Thanks Andy for reply!!

I have simple repeater which have 7 columns. In server side I am getting data through DataTable and binding directly. Client want sorting on entire data, so paging will be issue to apply on entire data.

I think repeater is taking time while rendering much of data.

Is there any solution to improve time.


<asp:repeater id="rptLocationList" runat="server" onitemcommand="rptLocationList_ItemCommand" xmlns:asp="#unknown">
<headertemplate>

<asp:linkbutton id="lnkFieldName" runat="server" commandname="FieldName">File Name	<asp:linkbutton id="lnkStatus" runat="server" commandname="Status">Status	<asp:linkbutton id="lnkLastModifiedDate" runat="server" commandname="LastModifiedDate">Last Modified Date	<asp:linkbutton id="lnkLastModifiedBy" runat="server" commandname="LastModifiedBy"> CssClass="hrefclass">Last Modified By	<asp:linkbutton id="lnkAvgYield" runat="server" commandname="AvgYield" cssclass="hrefclass">Avg Yield	<asp:linkbutton id="lnkOilOrNDFD" runat="server" commandname="OilOrNDFD" cssclass="hrefclass">Oil% Or NDFD

<itemtemplate>
<asp:hyperlink id="LinkStory" font-bold="true" font-underline="false" forecolor="Blue">
Style="white-space: nowrap;" runat="server" NavigateUrl='<%# Eval("FieldName", "~\ViewLocationDetails.aspx?LocationName={0}").Replace("#", "-hash-") %>'
Text='<%# Eval("FieldName") %>'>
<asp:hyperlink id="LinkConflicts" font-underline="false" enabled="<%#Eval(" statuslinkenable")="" %&gt;"="">
runat="server" Font-Bold='<%# Eval("StatusFontBold") %>' ForeColor='<%# System.Drawing.ColorTranslator.FromHtml(Eval("StatusForeColor").ToString()) %>'
NavigateUrl='<%# Eval("FieldName", "~\ManageConflicts.aspx?LocationName={0}").Replace("#", "-hash-") %>'
Text='<%# Bind("Status") %>' ToolTip='<%#Eval("StatusLinkToolTip") %>'>
<%#DataBinder.Eval(Container.DataItem, "LastModifiedDate", "{0:MM/dd/yyyy}")%>
<asp:label runat="server" text="<%#Eval(" lastmodifiedby")="" %&gt;"="" style="white-space: nowrap;">
<%#DataBinder.Eval(Container.DataItem, "AvgYield")%>
<%#DataBinder.Eval(Container.DataItem, "OilOrNDFD")%>
<asp:imagebutton id="btnView" commandname="View" commandargument="<%#Eval(" fieldname")%&gt;"="">
ImageUrl='<%#Eval("btnViewImageUrl")%>' Enabled='<%#Eval("btnViewEnable")%>'
runat="server" ToolTip="View/ Print Location Details Report" OnClientClick="frmFTDMain.target ='_blank'; document.location.href=document.location.href; " />
<asp:button id="btnUpload" causesvalidation="false" commandname="Upload" runat="server">
ToolTip="Upload template" Enabled='<%#Eval("btnUploadEnable")%>' CssClass='<%#Eval("btnUploadCssClass")%>'
UseSubmitBehavior='<%#Eval("btnUploadSubmitBehaviour")%>' OnClientClick='<%# String.Format( "return openWinUpLoad(""{0}"", ""{1}"",""{2}"",""{3}"");" , Eval("FieldName") , Eval("Crop"),Eval("UserName"), Eval("Status") )%>' />
<asp:button id="btnDownload" style="display: none" text="Download" commandname="Download">
OnClientClick="Disclaimer()" CommandArgument='<%#Eval("FieldName")%>' runat="server" />

onclick="Disclaimer('<%#Eval("FieldName").ToString().Replace("'", "-apostrophe-")%>')" />
<asp:imagebutton id="btnSubmit" imageurl="<%#Eval(" btnsubmitimageurl")%&gt;"="" runat="server">
OnClientClick='<%# String.Format( "return OnSubmit(""{0}"", ""{1}"");" , Eval("Crop") , Eval("AvgYield") )%>'
CommandName="Submit" Enabled='<%#Eval("btnSubmitEnable")%>' CommandArgument='<%#Eval("FieldName")%>'
ToolTip="Submit template" />
<asp:imagebutton id="btnDel" imageurl="<%#Eval(" btndeleteimageurl")%&gt;"="" runat="server">
CommandName="Delete_Field" Enabled='<%#Eval("btnDeleteEnable")%>' CommandArgument='<%#Eval("FieldName")%>'
ToolTip="Delete template" OnClientClick='<%# String.Format( "return ConfirmOnDelete(""{0}"");" , Eval("FieldName") )%>' />


<footertemplate>





And server side code :

rptLocationList.DataSource = dtLocations
rptLocationList.DataBind()

这篇关于中继器响应时间的改善的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！