Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
Showing results for 
Search instead for 
Did you mean: 

Creating search index for incremental loads

I have data coming from a SQL server, and I did an incremental load because there is a lot of data. However, I realized it still takes like 10 mins to load because it is creating a search index field. I was wondering if there is a way to only create search indexes on newly added data?

Labels (2)
1 Reply

The search index is created at the end of the reload for the entire data model, there is no way to control what it indexes.

However for extract apps, it's usually a good idea to disable the search index, this is detailed in the Qlik help site, and below:


Example 1: Create search index fields during data reload (DEFAULT)

set CreateSearchIndexOnReload=1;

Example 2: Create search index fields after first search request

set CreateSearchIndexOnReload=0;