I would be very careful with the materialized view.

There is a lot of potential for blocking or deadlocks, so you may find it just makes things worse.