topic Re: What is mean by Optimized Qvw in QlikView

What is mean by Optimized Qvw

NavinReddy — Mon, 22 Apr 2013 11:08:35 GMT

Hi All,

Plz guide me What is Optimization

How can we Do this in QVD and Application

what are the techniques we follow to Optimization

Thanks in Avance

Niranjan

Re: What is mean by Optimized Qvw

Sat, 27 Apr 2013 18:07:51 GMT

HI ,

One of the aspect in the Optimization is the Optimised Load.

If the Data is loaded from the Qvd in to Application without having any conditions on field values is considered as

Optimised load.

During this the Speed is fast as the Data is just moved from the Disk to the RAM and also there wont be any much change in the Size of the Qvw document .

//Yusuf

Re: What is mean by Optimized Qvw

NavinReddy — Sun, 28 Apr 2013 03:15:38 GMT

Hi Yusuf,

Thanks a lot for your reply ,

Plz Give me one example where can we use in Script

Thanks & Regards

Niranjan

Re: What is mean by Optimized Qvw

Sun, 28 Apr 2013 05:04:35 GMT

HI ,

If we consider a Document to show the Employee Details , Managers Details and Salary .

In DataBase we have 3 tables Employee , Manager and Salary .

First we have to use Source Document which doesn't any UI object . this document just connects to the Database and Generate the Qvd's and place it under certin folder

ex: 1. Qvds/Employee.qvd 2. Qvds/Salary 3. Qvds/Manager

and the size of the all Qvds are 20MB.

If there is no link exists wee have to create the Link .

Then in the User Documents we have to refer these Qvds Directly from the Above folder .

If we consider the Size of the empty Qvw document is 500KB so if we load these qvds we load data in the Qvw document and the Size of the Qvw becomes : 20,500 KB .

For Optmised load just load the Qvds and dont have any cinditions on the Field values , if you have do it in the Source document .

//Yusuf

Re: What is mean by Optimized Qvw

NavinReddy — Sun, 28 Apr 2013 09:46:27 GMT

Hi Yusuf,

Explanation is very nice i understand very well

Thanks a lot

Niranjan

Re: What is mean by Optimized Qvw

Anonymous — Sun, 28 Apr 2013 09:56:26 GMT

Niranjan

This blog post by Steve Dark gives a good explanation of Optimized Loads.

http://www.quickintelligence.co.uk/qlikview-optimised-qvd-loads/

Best Regards, Bill