Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Diff between optimized vs unoptimized?

Diff between optimized vs unoptimized?

8 Replies
oknotsen
Master III
Master III

About 10 times the loading speed.

If that was not the answer you are looking for, could you please tell us your question in more details.

May you live in interesting times!
Not applicable
Author

Hi,

Can you explain in details ?

Thanks.

marcelviegas
Creator II
Creator II

About 10 times the loading speed.

So it is advisable not to treat the data at the time of extraction but to transform into a qvd and treat the data.



buzzy996
Master II
Master II

if a qvd does not have any transformation activities except renaming of field then we can call it's optimized qvd else non optimized qvd.

oscar_ortiz
Partner
Partner

You can think of an unoptimized load as reading the table one record at a time.

Whereas, the optimized load is reading in chunks of records at a time.

If your QVDis relatively small you will hardly notice a difference.  When you are working with larger QVDs you will definitely see the impact.  Then you could look at the links that kush141087‌ mentioned to help you out.

Good luck

Oscar

Peter_Cammaert

"optimized" vs "unoptimized" only applies to reading QVDs, not to any other data source like table files or RDBMS.

Not applicable
Author

Thanks Oscar.