Speed up Load

[Anonymous]

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.

[simospa]

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 · Accepted solution]

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

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

[Anonymous]

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]

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]

It's ok.

Have a nice day!

S.