topic Re: What is optimized and unoptimized qvd ? in App Development

What is optimized and unoptimized qvd ?

Anonymous — Tue, 12 Dec 2017 10:37:45 GMT

What is optimized and unoptimized qvd ?

Re: What is optimized and unoptimized qvd ?

ashwinishinde — Tue, 12 Dec 2017 10:44:36 GMT

hello,

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.

Re: What is optimized and unoptimized qvd ?

Anonymous — Tue, 12 Dec 2017 10:53:15 GMT

Can you please explain me in very basic level.

Re: What is optimized and unoptimized qvd ?

ashwinishinde — Tue, 12 Dec 2017 11:13:47 GMT

As per my knowledge , a simply way to define is:

A load from qvd with out any transformation is optimized load

A load from qvd with data transformation will be un- optimized

eg:

optimized

load * from a.qvd

un-optimized :

load if(column1='a', column2-1, column2-3) as new column,

from a.qvd

Re: What is optimized and unoptimized qvd ?

MK9885 — Tue, 12 Dec 2017 19:45:10 GMT

Optimized QVD is 'As IS' fields with no transformation

Un-optimized is with transformation as Ashwini explained above

Optimized QVD always loads fast compared to Un-optimized. Even if you transform your QVD, store it and then read the QVd back again, so that it runs faster (if space is not an issue on server)