In case you wanna give it a try:
https://gist.github.com/Scythe42/ec08732c33c25db1f44532207bbf0f99
Replaces all the views in the Movie DB with tables updated by triggers.
Should contain all the changes I made. Hopefully did not make any copy and paste errors when taking out of the DB into the script.
Changing the Episode View, TV Show Counts and Movie View does only give a small speed boost. On TV Show View and especially Season View there is a significant improvement.
Have not done the Music Video View as I do not have any stored. If wished I can add it as well.
Let me know if it works out for you or what bugs you find.
For fallback: rename the _orig view back to their original name and remove the added "call update" procedures from the triggers. Should be straight forward.