[danielmarkbruce]

Materialized views help with this. It might not be perfect, but it isn't as bad as you say.