How do you optimize QV Application.?

.Merge tables to reduce joins at run time, create flatter structure at load time.
Optimize QV in UI/Application levela) Try to avoid no of macros
b) Try to implement or use all complex calculation in script level not in UI
c)Avoid same charts in different tabs

Optimization in script levela) Avoid synthetic keys and circular loops
b)use QVD’s
c)try to use star schema instead of snowflake schema