SharePoint列表与数据库表的性能 [英] SharePoint Lists vs Database Tables performance
问题描述
- 我们希望将交易数据存储在SharePoint列表中.列表将轻松增长到100,000多个项目.
- 如何将查询性能与具有这些列的数据库表上的查询进行比较?
查询: 按编号选择 选择ColumnValue = X的位置 按订单编号分组 按日期分组
Queries: Select by Id Select Where ColumnValue = X Group By OrderId Group By Date
SP列表将宽6列:ID，日期，OrderId(查找)，数量，项目名称，标题
The SP List will be 6 columns wide: Id, Date, OrderId (Lookup), Quanity, ItemName, Title
推荐答案
不要这样做. SharePoint不能很好地处理事务数据，并且性能会很差.
Don't do it. SharePoint is not good at handling transactional data and will perform badly.
您可能需要在数据库级别提高性能的任何功能(例如添加索引)都可能对SharePoint安装产生不利影响(尽管列表中的列可以通过SharePoint进行索引".
Any abilities you might have to improve performance at the database level (like adding indexes) may have detrimental effects on the SharePoint installation (although columns in lists can be "indexed" through SharePoint.
SharePoint本质上是为特定目的(内容/文档)而设计的，并且试图使其变得与众不同，这意味着您必须与应用程序打拼.
Essentially SharePoint is designed for a specific purpose (content/documents) and trying to get it to do something out of the ordinary means you have to fight the application tooth and nail.
幸运的是，SharePoint具有多种将事务数据集成到其中的方法.
Fortunately SharePoint has several means of integrating transactional data into it.
首先(如果您拥有更昂贵的企业许可证)，您将拥有业务数据目录，该业务数据目录允许您导入看起来类似于列表项的数据库值.
First off (if you have the more expensive Enterprise licence) you have the Business Data Catalog that allows you to import database values that will appear similar to list items.
如果您没有企业许可证，我可以建议您使用自定义控件/Web部件或数据视图" Web部件，以允许将这些数据显示"在SharePoint的相关页面上.
If you do not have the Enterprise licence, I can recommend either custom controls/webparts or the Data View Web Part to allow that data to be "shown" on the relevant pages within SharePoint.
总结: 与将数据存储在传统数据库应用程序中并集成到SharePoint的其他应用程序设计相比，您可以通过在SharePoint中存储事务数据来为很多不必要的工作做好准备.
In summary: You will be setting yourself up for a lot of uneccesary work by storing transactional data within SharePoint compared to other application designs hosting the data in traditional database applications and integrating to SharePoint.
这篇关于SharePoint列表与数据库表的性能的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
