Hacker News new | past | comments | ask | show | jobs | submit login

You can similarly use materialized views for this type of denormalization. When an update to the source tables occur you can trigger a view refresh.



Yes, very possible. This is a multi-tenant application so I don't want to trigger a view refresh so frequently as most updates don't affect most people.




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: