Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Speed up Load


Hi All,

I am currently trying to load a small table in Qlikview that extracts a created date from a large record set where the record ID exists in another table.

The load statement I am using is below. The first record I want to extract starts after caseID 1597000 hence trying to put the greater than statement in. While the load works it takes over 2 hours to run. can anyone suggest a quicker way to perform the load. I have tried a mapped load and also a join but they also take a long time to run. For info the extract to date will be about 1000 records but will grow daily.

if(caseID>1597000,caseID),

      
Date(createdDateTime, 'DD/MM/YYYY') as createdDate

where exists (caseID,caseID);

SQL SELECT

    caseID,

    createdDateTime

    FROM myDatabase;

Thanks for your help.

1 Solution

Accepted Solutions
rubenmarin

Hi Clive, to speed up set the WHERE clause in the SQL SELECT:

SQL SELECT
    caseID,
    createdDateTime
    FROM myDatabase Where CaseID>1597000;

View solution in original post

5 Replies
simospa
Partner - Specialist
Partner - Specialist

Hi,

did you try with

SQL SELECT

    caseID,

    Date(createdDateTime, 'DD/MM/YYYY') as createdDate


    FROM myDatabase

WHERE caseID>159700;

?

Let us know...

S.

rubenmarin

Hi Clive, to speed up set the WHERE clause in the SQL SELECT:

SQL SELECT
    caseID,
    createdDateTime
    FROM myDatabase Where CaseID>1597000;

Anonymous
Not applicable
Author

Thanks Ruben this worked great I did not think to add the greater than clause in the SQL statement I thought it had to be in the load statement. the load time has gone from approximately 2 hours to 30 seconds.

Anonymous
Not applicable
Author

Thanks Simone you hit the nail on the head with this one. I went with Rubens answer but only because I prefer to keep my field renaming in the load statement rather than the SQL statement (I do not have an idea if that makes a difference at all). The load has gone from approximately 2 hours to 30 seconds.

simospa
Partner - Specialist
Partner - Specialist

It's ok.

Have a nice day!

S.