Tips and pointers on how to optimize a model and make it load quicker??

Tue, 06 Nov 2012 08:52:24 GMT

Re: Tips and pointers on how to optimize a model and make it load quicker??

Tue, 06 Nov 2012 11:30:40 GMT

Hi,

You could try to:

1. Eliminate synthetic keys, if any.

2. Keep data transformations at a minimum, whereever possible.

3. Avoid using heavy calculations like nested if conditions, particularly if you are dealing with a large dataset unless really necessary.

4. Use QVDs to load data if and where applicable.

5.If the application is too big, split the application into multiple smaller apps.

Plus, you can check out the following threads for expert advice:

You can also download the attachment for QlikView optimization best practices from the following link:

Hope that helps.

Regards,

-Khaled.