4 ms·
Our initial approach was to store the full board in a single row in Cassandra and each request for the full board would read that entire row. This is the epito
by tupshin 9y ago
Our initial approach was to store the full board in a single row in Cassandra and each request for the full board would read that entire row.
This is the epitome of an anti-pattern .I sincerely hope that this approach was floated by somebody who had never used Cassandra before.
Even if individual requests were reasonably fast, you are sticking all of your data in a single partition, creating the hottest of hot spots and failing to leverage the scale out nature of your database.
- spyspy 9y agoThis entire project is just an elaborate hack day project. There's no reason to fault them for trying new and interesting hacks to get it off the ground. They realized it wasn't the right method and moved on. End of story.
- er8h 9y agoThey're using (timestamp, user) as their compound key, which would partition rows by timestamp, no?