Overview
Sometimes it gets confusing which is which, so I’ll leave a note.
Differences Between Sharding and Partitioning
| Item | Sharding | Partitioning |
|---|---|---|
| Method of Data Division | Horizontal (≈ horizontal partitioning) ex. Row | Vertical ex. Table, Database, Column |
| Advantages | Improved performance, enhanced scalability | Improved performance, better data searchability |
| Disadvantages | Increased complexity of data and management | Issues with data separation and consistency |
| Suitable Applications | Applications with large database sizes and declining performance | Applications where database access patterns are biased towards specific columns |
References
- Database sharding vs partitioning
What is the difference between sharding and partitioning? 【Distributed Database】
