SharePoint 列表与数据库表的性能
- 我们希望将交易数据存储在 SharePoint 列表中.这些列表很容易增加到 100,000 多个项目.
- 查询性能与对具有这些列的数据库表的查询相比如何?
查询:按 ID 选择选择其中 ColumnValue = X按订单 ID 分组按日期分组
Queries: Select by Id Select Where ColumnValue = X Group By OrderId Group By Date
SP 列表将有 6 列宽:Id、Date、OrderId(查找)、Quantity、ItemName、Title
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.
相关文章