实体框架和分片数据库 [英] Entity Framework and sharded database

问题描述

我有一个WCF数据服务在Entity Framework代码优先4.1提供程序的顶部运行.该数据库非常大(一个关键表具有77+百万条记录，并且每月增长约10％)，并且存在相当大的性能问题.虽然将数据库分片成一个大块是一件痛苦的事情，但这似乎是不可避免的.我的问题是，有人用分片数据库成功实现了EF吗?如果是，您有什么指导吗?

I have a WCF Data Service running on top of a Entity Framework code first 4.1 provider. The database is quite large (one key table has 77+ million records and grows by ~10% per month) and has presented quite a performance problem. While sharding a database that large is a pain it seems inevitable. My question is, has anybody successfully implemented EF with a sharded database and, if so, do you have any guidance?

推荐答案

您可以使用MS分片映射管理器扩展数据库.

You can scale out databases with the MS shard map manager.

请参阅Elastic数据库工具 https://azure.microsoft.com/zh-CN/documentation/articles/sql-database-elastic-scale-introduction/

See Elastic database tools https://azure.microsoft.com/en-us/documentation/articles/sql-database-elastic-scale-introduction/

，尤其是碎片图管理器

and in particular Shard map manager https://azure.microsoft.com/en-us/documentation/articles/sql-database-elastic-scale-shard-map-management/

这篇关于实体框架和分片数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！