Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

Not applicable

What is the best way to load data when the data source is huge like huge tables?

Would it be better to create QVDs and load the tables or load it via buffer or incremental load or partial load? What do you suggest?

3 Replies
MVP
MVP

Re: What is the best way to load data when the data source is huge like huge tables?

Create QVD for initial data load and use Incremental Load

Not applicable

Re: What is the best way to load data when the data source is huge like huge tables?

How about Buffer or is it the same like incremental?

MVP & Luminary
MVP & Luminary

Re: What is the best way to load data when the data source is huge like huge tables?

BUFFER is the same as incremental only when loading from text files. If loading from database, BUFFER will do a full reload and therefore will not give any performance improvement.

-Rob

Community Browser