花时间加载asp.net页面 [英] Take time to load the page of asp.net

问题描述

我有2个下拉列表，每个记录大约10000个，以及使用分页运行的11000记录的数据网格视图。代码没问题。



当我在实时服务器上运行这个Web应用程序时它运行速度很快但是当我在某个工作站运行时，它需要一些时间来加载页面。



正如我已经看到日志所有页面加载事件已经成功执行但是需要时间才能在工作站上显示。



你能告诉我问题出在哪里。

I have 2 drop down having a record of around 10000 each and a datagridview of 11000 record which is run using paging. No problem with code.

When i run this web application in a live server it will run fast but when i run in some workstation it will take time to load the page.

As i have seen the log all the page load event have executed sucessfully but it will take time to show at workstation.

Can you suggest me where is the problem.

推荐答案

问题是你有10,000个记录的下拉列表和11,000个数据网格。这些信息对于任何人来说都太过分了，并且总是会导致网站速度变慢。将下拉列表替换为自动完成功能，以便用户只查看他们键入的记录，并将网格中的数据限制为仅限于相关数据（同样，您可能需要search \ filter函数，否则它可能会运行如有必要，自动完成框。）

The problem is that you have dropdowns with 10,000 records and a datagrid with 11,000. This information is too much for any human being to process and it is always going to result in a slow site. Replace the dropdown with an auto complete feature so the user only sees records they type for, and restrict the data in the grid to only relevant data also (again you might need a search\filter function or it could run off of what is in the auto complete box if necessary).

绑定可能需要一段时间

因此使用sql动态quries asp.net数据集可以更快地从动态quires中绑定数据/>


其被调用的SQL参数嗅探



例如：

声明@parameter为varchar（max）



set @ parameter ='从表中选择*



exec @parameter

It might take time at binding
So use sql dynamic quries asp.net dataset binds data faster from dynamic quires

Its Called SQL Parameter Sniffing

For Example :
declare @parameter as varchar(max)

set @parameter='Select * from Table'

exec @parameter

这篇关于花时间加载asp.net页面的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！