Optimizatio

[#1]

Hi,

How to do advance Optimization  when basic optimization is done already.

[Anonymous · Accepted solution]

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!!

[robert_mika]

Not sure what you mean by basic but small addition what already has been said:

-save your tables to QVD

-remove redundant fields,tables