太多数据限制控件导致ASP.NET性能问题？ [英] too many data bounded controls causing ASP.NET performance issues?

问题描述

您好，



希望一切顺利，我在ASP.NET Web应用程序上遇到性能问题，我认为问题在于可能有太多数据我的网络表单上的有界控件（下拉列表，网格等）。



这会导致性能问题吗？



我在一个ASPX页面上有所有表格，然后根据选项卡的选择等显示相关内容。



我的问题是所有这些SqlDataSources在页面加载期间从数据库服务器读取数据？我不确定是否是这种情况或问题，但似乎所有页面中的所有数据源都可能在加载页面时加载数据，这反过来导致网页速度太慢。



还有太多的SqlDataSource会导致性能问题吗？我可以在这件事上找到任何东西...感谢您的反馈和信息...



非常感谢！

Shirzad Sharif

Hello,

Hope all is well, I am experiencing performance issues on my ASP.NET web application, I think the problem resides with possibly having too many data bounded controls (dropdown lists, grids, etc.) on my web form.

Can this cause performance issues?

I have all of the forms on one ASPX page, which in turn displays relevant content based on selection of tabs, etc.

My questions is are all these SqlDataSources reading data from the database server during page load? I am not sure if this is the case or the problem but it seems like potentially all datasources from all pages are loading data when the page is loaded which in turn is causing the web page to be way too slow.

Also does having too many SqlDataSources cause performance issues? I can find anything on this matter... appreciate your feedback and info...

Many Thanks!
Shirzad Sharif

推荐答案

谢谢，我最终做的是使用ObjectDataSource而不是SqlDataSource，这似乎非常重要，因为它向应用程序添加了DLA（数据访问层）。



http://www.c-sharpcorner.com/UploadFile/6897bc/using-objectdatasource-control-and-its-advantage-over-sqldat/ [ ^ ]



最后也发布了网站，它似乎运行速度明显快于调试，这让我调查Visual Studio设置进行一些更改，以便调试器运行得更快.. 。



我仍​​然对进行数据访问方式的进一步优化感兴趣，但我将不得不在以后这样做。



谢谢，

Shirzad

Thanks, what I ended up doing was use the ObjectDataSource instead of SqlDataSource, this seems to be pretty significant as it adds a DLA (Data Access Layer) to the application.

http://www.c-sharpcorner.com/UploadFile/6897bc/using-objectdatasource-control-and-its-advantage-over-sqldat/[^]

Also ended up publishing the website and it seems to run significantly faster than in debug, which made me look into Visual Studio settings to make some changes so the debugger runs faster...

I am still interested in further optimizations to the way data is being accessed, but I will have to do this at a later date.

Thanks,
Shirzad

这篇关于太多数据限制控件导致ASP.NET性能问题？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！