Qlik Community

New to Qlik Sense

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

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

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
peter_turner
Partner
Partner

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;