Qlik Community

Qlik Sense Data Connectivity

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Not applicable

Reload data

Hi,

this is my first chat in qlik. I'm working with Qlik Sense, the last version, from a little tmie and I found a problem.

I have created a OLEDB connection with SQL Server. Since the time of data reload  is very long, exist a solution to reload a part of code (a part of data) ? So, if I want load some data only, I don't must load entire database.

2 Replies
dwforest
Valued Contributor

Re: Reload data

If you are loading from the Data Load Editor, there is an option for debugging, the bug button to the left of the Load Data button.

In the panel that appears on the bottom of the screen is a Limited load check box, check it and specify the number of rows.

if you are looking to long term reduced the load time from data base, you want to look into an Incremental load, which is explained in the help

http://help.qlik.com/en-US/sense/3.2/Subsystems/Hub/Content/LoadData/use-QVD-files-incremental-load....

callen973
New Contributor III

Re: Reload data

Another issue might be how you are loading the data, meaning are you doing any derived fields in the load script portion. This will slow things down also as it needs to perform the additional actions.