topic Re: Is the script performance better if the LOAD statement is not needed for a SQL table? in App Development

Is the script performance better if the LOAD statement is not needed for a SQL table?

jblomqvist — Thu, 26 Jul 2018 08:36:41 GMT

Hi there,

I have a question about performance.

Let's say you have a LOAD statement on top of a SQL Select statement.

If you do not need to do any changes to the fields from the SQL Select, is the performance better by removing the LOAD statement and loading the fields there again?

Let's say the SQL Select fields data is fine, you do not need to change the field names etc.

Re: Is the script performance better if the LOAD statement is not needed for a SQL table?

BalaBhaskar_Qlik — Thu, 26 Jul 2018 10:11:13 GMT

It may also depends, on Data volume.

Re: Is the script performance better if the LOAD statement is not needed for a SQL table?

jblomqvist — Mon, 30 Jul 2018 12:22:02 GMT

Let's say the data volume is "low".

Re: Is the script performance better if the LOAD statement is not needed for a SQL table?

dapostolopoylos — Mon, 30 Jul 2018 12:24:15 GMT

I belive in your case the SQL statement is enough.

Have in mind that if your data are preety low then you won't see differences in performance with "naked eye".

Re: Is the script performance better if the LOAD statement is not needed for a SQL table?

BalaBhaskar_Qlik — Mon, 30 Jul 2018 12:39:45 GMT

Load Statement on top of SQL should not be used if not doing any calculations or deriving new fields, this will load the same data.

Ex:

Emp:

Load

Capitalize(ename) AS ename_Formatted,

MonthName(date) AS MonthYear,

Week(date) AS Week;

SQL

Select empid,

ename,

loc,

date

from emp;

The Load statement on top of select statement is used to transform the retrieved data from database, it is not mandatory to use Load statement on top of select statement. We will use when we are doing any calculations or arriving new fields like Above.

SQL statement pulls the dat from DB , and LOAD statement works on top of that data , and performs operations that coded in load statement and stores the results in QlikView.

EX:

SQL

Select empid,

ename,

loc

from emp;

And through this script what should be result

ABC:

Load

SQL

Select empid,

ename,

loc

from emp;

The first example could be a tiny bit faster since it doesn't use a preceding load. The end result is exactly the same since the preceding load in your second example doesn't do transformations or calculations.