- Building Microservices with .NET Core 2.0(Second Edition)
- Gaurav Aroraa
- 190字
- 2021-07-02 20:12:55
Big database
Our current application has a mammoth database containing a single schema with plenty of indexes. This structure poses a challenging job when it comes down to fine-tuning the performance:
- Single schema: All the entities in the database are clubbed under a single schema named dbo. This again hampers business due to the confusion with the single schema regarding various tables that belong to different modules; for example, customer and supplier tables belong to the same schema, that is, dbo.
- Numerous stored procedures: Currently, the database has a large number of stored procedures, which also contain a sizeable chunk of the business logic. Some of the calculations are being performed within the stored procedures. As a result, these stored procedures prove to be a baffling task to tend to when the time comes to optimize them or break them down into smaller units.
Whenever deployment is planned, the team will have to look closely at every database change. This, again, is a time-consuming exercise and many times would turn out to be even more complex than the build and deployment exercise itself.
推薦閱讀
- PHP動態網站程序設計
- 區塊鏈架構與實現:Cosmos詳解
- Vue.js 3.0源碼解析(微課視頻版)
- Python 3網絡爬蟲實戰
- PhpStorm Cookbook
- Oracle Exadata專家手冊
- Cocos2d-x學習筆記:完全掌握Lua API與游戲項目開發 (未來書庫)
- The DevOps 2.5 Toolkit
- Node.js Design Patterns
- RESTful Java Web Services(Second Edition)
- SQL Server 2008 R2數據庫技術及應用(第3版)
- RubyMotion iOS Develoment Essentials
- Practical Predictive Analytics
- Flink核心技術:源碼剖析與特性開發
- 信息學奧林匹克競賽初賽精講精練