与SharePoint和Telerik的radgrid控件控制性能问题 [英] Performance issues with SharePoint and Telerik RadGrid Control

问题描述

我最初发布<一个href=\"http://stackoverflow.com/questions/6429132/how-can-i-track-the-source-of-slowness-for-my-scenario\">this问题来缩小与我的SharePoint应用程序缓慢的问题。之后接受 StriplingWarrior的答案，我开始逐步执​​行他的建议。概括地说，我有一个托管的SharePoint 2010服务器上的应用页面中的radgrid控件。该radgrid控件分页时运行完美的罚款;然而，一旦应用了过滤器，例如：给我，包含母鹿（使用Telerik的内置过滤机制），结果向上15秒取返回姓氏。这不会发生在我的开发环境，使用同一套数据（约30000条记录）的。

有两点要注意这里：

• 这是由我的LINQ产生到SQL前pressions的SQL都是精品。我跟踪他们LINQPad并放置他们到Management Studio中。没有什么复杂的事情出现。


• 我创建一个空的ASP.NET 3.5 Web窗体应用程序，并移植违规RadGrids之一。我把Web应用程序在生产服务器上，不会你知道...它跑就好了。过滤。在没有性能问题

因此​​，通过做上述情况，我能排除以下内容：

• 数据库优化的问题。


• SharePoint应用程序和数据库服务器之间的网络问题。


• 的LINQ to SQL优化的问题。

在这种情况下，从高层次看，你能想到的任何东西，我需要在SharePoint应用程序服务器上做或以其他方式来解决这个问题？我已经调试在web.config关闭。

再次<一个href=\"http://stackoverflow.com/questions/6429132/how-can-i-track-the-source-of-slowness-for-my-scenario\">here我是一个包含code 原来的问题。谢谢你。

解决方案

主要发生是由于以下原因的SharePoint性能问题：

• 的BLOB SQL Server负载过重


• 对列表太多数据库车次

如果你使用一些智能技术，这是可以显着改善性能的SharePoint

• 外部化文档（BLOB）的


• 缓存列表和BLOB的

Microsoft Office SharePoint服务器（MOSS）是一个非常受欢迎的产品，提高了通过内容管理和企业搜索，共享业务流程和信息共享跨边界的组织效益更好的业务洞察力。而StorageEdge是一个非常精细的产品，增强/改进的SharePoint性能。

I originally posted this question to narrow down the slowness issues with my SharePoint application. After accepting StriplingWarrior's answer, I began to step through his suggestions. In a nutshell, I have a RadGrid within an Application Page hosted on a SharePoint 2010 Server. The RadGrid runs perfectly fine when paging; however, once a filter is applied, ex: give me last names that contain 'doe' (using Telerik's built-in filter mechanism), the results take upwards of 15 seconds to return. This does not occur in my development environment, using the same set of data (approx 30,000 records).

A couple of notes here:

• The SQL which is produced by my LINQ to SQL expressions are fine. I traced them with LINQPad and placed them into Management Studio. Nothing complex going on there.
• I created an empty ASP.NET 3.5 Web Forms application and ported one of the offending RadGrids. I placed the web application on the production server and wouldn't you know...it ran just fine. No performance issues when filtering.

So by doing the aforementioned, I was able to rule out the following:

• Database optimization issues.
• Network issues between the SharePoint application and database server.
• LINQ to SQL optimization issues.

Looking at this case from a high-level, can you think of anything that I need to do on the SharePoint application server or otherwise to fix this issue? I have debugging turned off in the web.config.

Again, here is my original question that contains the code. Thank you.

解决方案

The SharePoint performance problems occur primarily due to the following reasons:

• BLOBs overwhelm SQL Server
• Too many database trips for lists

You can dramatically improve SharePoint performance if you use a few of intelligent techniques which are:

• Externalize Documents (BLOBs)
• Cache Lists and BLOBs

Microsoft Office SharePoint Server (MOSS) is an extremely popular product that improves effectiveness of organizations through content management and enterprise search, shared business processes, and information-sharing across boundaries for better business insight. And StorageEdge is an extremely fine product that enhance/improve SharePoint performance.

这篇关于与SharePoint和Telerik的radgrid控件控制性能问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！