Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I want to know load time for each table at script execution (in log file etc).
For example: I am using number of tables in script (data model), i want ot know which table is taking much time by the reload.
Thanks,
Nihhal.
Hi Kushal,
I am getting script line error at
LET LoadTimeTable2 = interval($(vEndTimeTable2) - $(vStartTimeTable2),'hh:mm:ss' );
Try this:
LET vStartTable1 = Num(Now());
Table1:
LOAD 1 as Dim1
AutoGenerate 50000;
LET vEndTable1 = Num(Now());
LET LoadTimeTable1 = $(vEndTable1) - $(vStartTable1);
Using Kush's idea:
// Table1
LET vStartTable1 = Num(Now());
Table1:
LOAD 1 as Dim1
AutoGenerate 5000000;
LET vEndTable1 = Num(Now());
LET LoadTimeTable1 = $(vEndTable1) - $(vStartTable1);
// Table2
LET vStartTable2 = Num(Now());
Table2:
LOAD 2 as Dim2
AutoGenerate 50000000;
LET vEndTable2 = Num(Now());
LET LoadTimeTable2 = $(vEndTable2) - $(vStartTable2);
// Table3
LET vStartTable3 = Num(Now());
Table3:
LOAD 3 as Dim3
AutoGenerate 1000000;
LET vEndTable3 = Num(Now());
LET LoadTimeTable3 = $(vEndTable3) - $(vStartTable3);
// Table4
LET vStartTable4 = Num(Now());
Table4:
LOAD 4 as Dim4
AutoGenerate 10000000;
LET vEndTable4 = Num(Now());
LET LoadTimeTable4 = $(vEndTable4) - $(vStartTable4);
// Table5
LET vStartTable5 = Num(Now());
Table5:
LOAD 5 as Dim5
AutoGenerate 40000000;
LET vEndTable5 = Num(Now());
LET LoadTimeTable5 = $(vEndTable5) - $(vStartTable5);
Info:
LOAD 0 as Dummy
AutoGenerate 0;
FOR i = 0 to 4
LET j = $(i) + 1;
Concatenate(Info)
LOAD Interval($(LoadTimeTable$(j)), 'hh:mm:ss') as Time,
TableName($(i)) as TableName
AutoGenerate 1;
NEXT
Not working.
I have attached a sample, check that
Thank you.