Table Load Time

[nihhalmca]

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.

[nihhalmca]

Hi Kushal,

I am getting script line error at

LET LoadTimeTable2 = interval($(vEndTimeTable2) - $(vStartTimeTable2),'hh:mm:ss' );

[sunny_talwar]

Try this:

LET vStartTable1 = Num(Now());

Table1:

LOAD 1 as Dim1

AutoGenerate 50000;

LET vEndTable1 = Num(Now());

LET LoadTimeTable1 = $(vEndTable1) - $(vStartTable1);

[sunny_talwar · Accepted solution]

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

[nihhalmca]

Not working.

[sunny_talwar]

I have attached a sample, check that

[nihhalmca]

Thank you.