Increase speed of script

[vchuprina]

Hi All,

I want to implement incremental reload because we get a lot of files and it's take a lot of time to load all files each time.

In script I create table to load filetime,

Time:

LOAD

  Num(FileTime()) AS CreatedTime

From

[$(vFile)]

($(vExcel), no labels, table is [$(vSheetName)])

;

LET vTime = Peek('CreatedTime', 0, 'Time');

DROP Table Time;

but I can't understand why script checked each line in sheet, for example if file have 36.507 lines, script load all of them.

[Gysbert_Wassenaar · Accepted solution]

You're using a straight forward load statement with no restrictions so it will load run FileTime() once for every record. Try this instead:

Time:

FIRST 1

LOAD

  Num(FileTime()) AS CreatedTime

From

[$(vFile)]

($(vExcel), no labels, table is [$(vSheetName)])

;

LET vTime = Peek('CreatedTime', 0, 'Time');

DROP Table Time;

[vchuprina]

Thank you, Gysbert. Now script works much more faster.