What is mean by Optimized Qvw

[NavinReddy]

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

[#2]

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

[NavinReddy]

Hi Yusuf,

Thanks a lot for your reply ,

Plz Give me one example where can we use in Script

Thanks & Regards

Niranjan

[#4]

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

[NavinReddy]

Hi Yusuf,

Explanation is very nice i understand very well

Thanks a lot

Niranjan

[Anonymous]

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