Data Sharding: Twitter Posts
Scenario Let's begin with a Twitter-like service that allows you to tweet new posts. The service has very high read and write traffic , we'll say ~10k »
RDBMS Indexing
Introduction As illustrated in this article, indexing is one of the easiest and most effective tweaks you can add to your SQL database. However, indexing might »
CAP Patterns
The CAP Theorem dictates that only two of its three characteristics can be guaranteed at any given time. Intro to CAP Consistency Every read will be »
RDBMS Optimization
Indexing Probably the easiest tweak to implement. It can usually be done with one SQL command. However, an index should be made based on a good »