topic Re: Need Help in QlikView

Need Help

subbareddykm — Tue, 15 Dec 2015 16:21:32 GMT

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

Re: Need Help

Tue, 15 Dec 2015 16:39:50 GMT

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!

Re: Need Help

subbareddykm — Tue, 15 Dec 2015 17:05:13 GMT

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

Re: Need Help

Colin-Albert — Tue, 15 Dec 2015 17:15:09 GMT

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?

Re: Need Help

JonnyPoole — Tue, 15 Dec 2015 17:17:41 GMT

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.

Re: Need Help

subbareddykm — Tue, 15 Dec 2015 17:20:31 GMT

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.

Re: Need Help

subbareddykm — Tue, 15 Dec 2015 17:22:30 GMT

Yah Colin,

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

Re: Need Help

Colin-Albert — Tue, 15 Dec 2015 17:35:25 GMT

Can you post the document log?

Re: Need Help

subbareddykm — Tue, 15 Dec 2015 17:38:22 GMT

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?

Re: Need Help

subbareddykm — Tue, 15 Dec 2015 17:40:26 GMT

Actually i dont have now. 😞

Re: Need Help

Colin-Albert — Tue, 15 Dec 2015 17:53:39 GMT

If you are joining 4 fields, then this will need 4 mapping tables and 4 apply maps. It should run much faster than a join though and avoids errors caused by incorrect joins causing data to duplicate.

I create the multiple mapping tables rather than using join wherever possible,

There are more details on the pros & cons here Don't join - use Applymap instead

Re: Need Help

Colin-Albert — Tue, 15 Dec 2015 17:58:05 GMT

There is a good blog by Steve Dark on ApplyMap here as well

http://www.quickintelligence.co.uk/applymap-is-it-so-wrong/

Re: Need Help

Colin-Albert — Tue, 15 Dec 2015 18:12:27 GMT

For testing use Debug mode, and set a limited load of 10, 100 or 1000 rows.

This will allow you to test your script without loading all the data and so will not take 2+ hours for each test.

Re: Need Help

subbareddykm — Tue, 15 Dec 2015 18:16:47 GMT

OKay well,

I want to ask you one thing if my QVD present in Production server and if reload in Development server,will it effect on reload time ?