Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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;