Kofax Insight Studio > Records > Create records > Use Insert-Select query

Use Insert-Select query

The Use Insert-Select query option can improve the performance significantly, because it causes the data to remain on the SQL server. By default, this option is disabled if the object - a record, a metric, or a translation table - is designed based on the tables from a data source. Conversely, the option is enabled if the object is designed based on other Insight objects.

If the Use Insert-Select query option is disabled, the data is loaded the following way.

  1. The Select query is sent to the data source and executed.

  2. The data is read by the system and incrementally added to memory.

  3. The added data is inserted to the Data DB database through Fast Insert.

If the option is enabled, the data can be loaded with a single Insert-Select query. In this case, if the tables are used to design the object, an access to a source database is required.

Note We recommend that you enable the option only if a single query is possible. Otherwise, the system returns an error when executing the data load.

To enable the Use Insert-Select query option, complete the following procedure.

  1. On the Documents Tree select Records, or Metrics, or Translation tables, and then select the required object to open them.
  2. On the SQL tab, select the Use Insert-Select query check box.
  3. Click Save.