Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

use of buffer load? help me

by using buffer prefix before load statement we can store as temp qvd in specified path...but what is the exact use of buffer?

2 Replies
el_aprendiz111
Specialist
Specialist

Hi,

This can serve

TMP:
LOAD * Inline
[
DAY,HOUR
DATE(),NOW()
]
;
STORE TMP into [..\..\..\Desktop\script\TmpQvd.qvd] (qvd);

DROP Table TMP;

Peter_Cammaert
Partner - Champion III
Partner - Champion III

The BUFFER prefix lets QlikView Script Engine create caches for individual data sources. This means that in a few particular cases (e.g. large database tables, or log files) most of the time you can avoid reloading from the slow original and take the data from the very fast QVD buffer. The prefix options allow you to specify when the scripting engine has to skip the buffer and take a peek at the original data source in order to avoid mismatches or ageing of data.