Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
I have timestamp in Sql Tables , Please Guide me how to write in script.
Vikas
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);
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.