Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
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 - Specialist
Partner - Specialist

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;