4 ms·
If you write often, another way is to use triggers. They can be extremely useful for this kind of scenerio.
by xiphias 10y ago
If you write often, another way is to use triggers. They can be extremely useful for this kind of scenerio.
- sp527 10y agoAgreed. Triggers are especially useful for maintaining counts. If you want to feel extra smug, there's a post from Instagram eng about how they realized they should denormalize counts of likes only pretty late in the game.
- sgeneris 10y agoThe basic issue is that derived data should not be included in base relations -- they belong in derived relations, such as views.