topic Re: SQL Scripting how improve the performance of SQL Queries or Incrementals to SQL Query in QlikView

SQL Scripting how improve the performance of SQL Queries or Incrementals to SQL Query

vikasmahajan — Thu, 08 Jan 2015 04:17:35 GMT

Dear All,

I want expert advise for how to improve SQL query performance We have sql data which takes approx 1 hour to pull

into qvd to overcome this situation can any one give idea how to implement the incremental load for SQL query to get faster data into qvd's.

Thanks in adv.

vikas

Re: SQL Scripting how improve the performance of SQL Queries or Incrementals to SQL Query

anbu1984 — Thu, 08 Jan 2015 05:28:02 GMT

Do you have timestamp in your source table to identify new/updated records?

If yes, then identify max(Timestamp) of previous load from your QVD file and use the same in your Sql to retrieve anything inserted/updated after max timestamp from your table

Re: SQL Scripting how improve the performance of SQL Queries or Incrementals to SQL Query

vikasmahajan — Thu, 08 Jan 2015 05:46:03 GMT

I have timestamp in Sql Tables , Please Guide me how to write in script.

Vikas

Re: SQL Scripting how improve the performance of SQL Queries or Incrementals to SQL Query

anbu1984 — Thu, 08 Jan 2015 05:58:56 GMT

Max_TS:

Load Max(Timestamp_field) As Max_Timestamp From YourQvd.qvd(qvd);

Let vMaxTS=Peek('Max_Timestamp',0,'Max_TS');

Tbl:

Sql Select Key,Field1,... From Table Where Timestamp > To_date('$(vMaxTS)','timestamp_format');

Concatenate

Load * From YourQvd.qvd(qvd) Where Not Exists(Key);

Store Tbl into YourQvd.qvd(qvd);

Re: SQL Scripting how improve the performance of SQL Queries or Incrementals to SQL Query

Thu, 08 Jan 2015 07:16:59 GMT

Hello Vikas,

Here is the incremental Load concent with all steps

in the same way by instead od date field use Timestamp to performa the task.