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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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;