Need Help

[subbareddykm]

Hi All,

I have some some question regarding optimizing QV application.

1.Present my application is taking reload time 2 and half an hour.

2.i want to reduce that time ? How ? Tell me some possible ways.even i m using All QVD's only.

3.Also i have five fact table .How do i make  single fact table. There iss no lnk between thosa fact tables ....

[#2]

Hi Subbardy. There are many ways to optimize your.

Some advices are:

1. Remove sintetic keys.

2. Remove circle's

3. Use numeric keys to match the tables.

4. Use dimension's but not too dimensions.

5. Use a fact table.

6. Remove objects that you don't use.

These are some of them. There are many, but you can start for these six.

Regards!

[subbareddykm]

I m following above points ,still its not loading quickly ? 😞

[Colin-Albert]

What is taking time - is the data load slow, or after all data has loaded is there a pause whilst synthetic keys are generated?

Have you enabled the document log, as this can indicate which sections of your script are taking time.

Are the QVD files hosted on the same server as QlikView is the data being loaded across a network?

Is the data being loaded from one large QVD or are you loading lots of small QVDs?

Are you joining tables in QlikView? - This can be very slow. -Can you use applymap instead of join.

If you are joining are the keys based on integers.

How many rows are in your fact tables?

[JonnyPoole]

I agree . Enabling the log file will show us the areas that take the longest amount of time.

That way we can fine tune the problem and identify / remediate specifc bottlenecks. That is your first step.

[subbareddykm]

Hi Colin,

App Relooad time taking more than two hours.

I m using Where Exist Function and Also i have Doc Log. I checked loag file also ,more tume taking tables are full optimized.

[subbareddykm]

Yah Colin,

I dont know what exactly the issue is it data model or anything else.

[Colin-Albert]

Can you post the document log?

[subbareddykm]

Yah i m using so many  left joins and keeps.

But if we want use applymap ther should be only two columns right ? I have more then 10 columns in my tables.

Can u tell me how use Applymap() instead of Left join anf keep, Means Some script examples?

[subbareddykm]

Actually i dont have now.  😞