628 karma · joined July 14, 2014
http://slatestarcodex.com/2013/05/22/the-wisdom-of-the-ancie...
This net neutrality victory is something to celebrate, but we need to keep the bigger goals in mind for this to not be suboptimal longer term.
Let's say I have a table containing data for many users, while each subscription only needs data for a single user. Instead of scanning through all the changefeeds, you could put subscriptions in a hashmap and figure out which ones to update in O(1) time rather than O(N) time in number ob subscriptions, per update.
Obviously this is much harder in the general case, but do you do anything along these lines?
The hard part is building out a change feed that lets you synchronize on a subset of a table in a way that is performant, and to make this work with joins (i.e. when you're using the database as more than just a document store).