topic Re: Diff between optimized vs unoptimized? in QlikView

Diff between optimized vs unoptimized?

Wed, 25 Nov 2020 16:16:04 GMT

Diff between optimized vs unoptimized?

Re: Diff between optimized vs unoptimized?

oknotsen — Wed, 23 Aug 2017 11:39:08 GMT

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.

Re: Diff between optimized vs unoptimized?

Kushal_Chawda — Wed, 23 Aug 2017 11:49:23 GMT

see this

Optimized and unoptimized QVD Load Situations? thanks in advance

Turning Unoptimized Loads into Optimized Loads

Re: Diff between optimized vs unoptimized?

Wed, 23 Aug 2017 11:50:52 GMT

Hi,

Can you explain in details ?

Thanks.

Re: Diff between optimized vs unoptimized?

marcelviegas — Wed, 23 Aug 2017 11:53:35 GMT

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.

Re: Diff between optimized vs unoptimized?

buzzy996 — Wed, 23 Aug 2017 12:53:55 GMT

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.

Re: Diff between optimized vs unoptimized?

oscar_ortiz — Wed, 23 Aug 2017 14:49:01 GMT

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

Re: Diff between optimized vs unoptimized?

Peter_Cammaert — Wed, 23 Aug 2017 15:31:22 GMT

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

Re: Diff between optimized vs unoptimized?

Thu, 24 Aug 2017 12:26:20 GMT

Thanks Oscar.