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 level
a) 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 level
a) Avoid synthetic keys and circular loops