Can anyone tell me what is meant by "Buffering the QVD" ?? "Why buffering is done" ??

[nikhilgarg]

Hey,

Can anyone tell me what is meant by "Buffering the QVD" ?? "Why buffering is done" ??

And also please tell me what is meant by following :

1: buffer SQL SELECT * FROM MyTable;

2: buffer (stale after 7 days) SQL SELECT * FROM MyTable;

3: buffer (incremental) LOAD * FROM MyLog.log;

Thanks

[MK_QSL]

What is buffer load? Explain it with example!

[maleksafa]

buffer is usually used when reading log files for example, since the old data that you have already retrieved will not be changed the next day.

so what is done in the case of an incremental buffer load, the first time it executes it will store the result of the query in a qvd and in the next day it will read the data first from the qvd (which is way more faster) and the incremental part will be read from executing the query.

[#4]

By Preceding a Load or SELECT statement with a BUFFER prefix, QlikView automatically creates a QVD file. During a later load, if certain conditions are met, is used instead of the original data source when reloading the data.

[#5]

check this very helpful

https://www.youtube.com/watch?v=1K7_WyksYxs