Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
dpurdy66
Contributor III
Contributor III
‎2021-11-18 09:14 AM

Minimally logged inserts

SQL Server can do minimally logged inserts when certain conditions are met.   This can improve performance and keep the transaction log from filling up.   As stated in the SQL Server documentation , the conditions for doing this with a "insert into ... select" statement are:

  • The recovery model of the database is set to simple or bulk-logged.
  • The target table is an empty or non-empty heap.
  • The target table is not used in replication.
  • The TABLOCK hint is specified for the target table.

Is there a way to get Compose to add a WITH (TABLOCK) to the insert statement it generates?   This would be particularly useful for loading staging and temporary tables.  It could also be used then "optimized for initial load" is selected for the task.

Labels (2)
Labels
412 Views
0 Likes
1 Reply
Adam_Herman
Support
Support
‎2021-11-19 10:29 AM

Hi @dpurdy66 , you can manually edit the query via Compose by going to the DWH panel, Press and Hold "CTRL" button, click on "ETL Commands" (while holding "ctrl"),  open the query you wish to edit, and click save once the changes are done. Kindly notice that you will be required to do same steps manually each time (for different queries) or whenever you regenerate the task 

On the other hand, if you suggest adding this hint as a permanent one in Compose (as a product suggestion), then you can submit a feature request via Ideation. You may use belw link for additional help on how to submit FR: 
https://community.qlik.com/t5/Knowledge/How-To-Submit-Feature-Requests-For-Qlik-Products/ta-p/171258....

 

Kind Regards,

Adam

 

 

381 Views