Hi,
Follow this steps:
Don't display huge data in tables like Table box, Straight Table, Pivot Table,
- Don't display all charts in a single shot, show/hide by using buttons or split into sheets.
- Perform all possible calculations in the script level itself and bring some flags wherever required.
- Load only required data instead of loading all the data in the database and required columns so that the size of the QVW file will be reduced.
- Always make your key columns as numeric, so that the joins will be faster. If your data is Text then use AutoNumber (),
- If you are not using Time part in the date fields for analysis remove it by using Date(Floor(DateFieldName)), a lot of memory will be saved.
- Restrict displaying huge data in tables by forcing users to select some filters.
- Try to create Star schema data model.
- Last but not the least remove all your synthetic keys and Circular references for better performance
Hope it helps!!
