2 Replies Latest reply: Aug 8, 2016 7:39 AM by Vitalii Chupryna RSS

    Increase speed of script

    Vitalii Chupryna

      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,




        Num(FileTime()) AS CreatedTime



      ($(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.