Diff between optimized vs unoptimized?

[#1]

Diff between optimized vs unoptimized?

[oknotsen]

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.

[Kushal_Chawda]

see this

Optimized and unoptimized QVD Load Situations? thanks in advance

Turning Unoptimized Loads into Optimized Loads

[#4]

Hi,

Can you explain in details ?

Thanks.

[marcelviegas]

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]

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]

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.

[#9]

Thanks Oscar.