2 Replies Latest reply: Aug 8, 2016 7:39 AM by Виталий Чуприна RSS

    Increase speed of script

    Виталий Чуприна

      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.

       

      Untitled.png