2 Replies Latest reply: Jul 8, 2016 11:59 AM by Miguel Braga RSS

    Table with big volume of data - Need for optimization

    annick whitfield

      Hello,

       

      I would like to display a simple table (i.e. 5 columns), but with millions of lines. I would like to have a condition on one of the column. Unfortunately, the performance are not good and I am seeking help for optimization.

       

      Here's my load script:

      Sale:

      Load * inline

      [

      SaleID, SaleAmount, SaleYear, SaleMonth, SaleCity, SaleDay

      101,      100,               2016,       1,                 PAR,        10

      102,      10,                 2016,       1,                 LON,         11

      103,      150,               2016,       3,                 HEL,          9

      104,      210,               2016,       4,                 FRA,          2

      105,      40,                 2016,       4,                 PAR,         13

      106,      345,               2016,       8,                 LON,         21

      107,      35,                 2016,       8,                 FRA,         25

      108,      50,                 2015,      1,                  PAR,         11

      109,      25,                 2015,      2,                  PAR,         15

      110,      235,               2015,      6,                  LON,          23

      111,      125,               2015,      8,                  FRA,          5

      112,      25,                 2015,      8,                  HEL,         25

      etc...

      ];

       

      I would like to display all the Sales made this year. Here's my table:

       

       

      I suspect that having the field "if(SaleYear= year(today()), SaleID)" as a dimension in the column of the table degrades the performance. Would you have any recommendation in order to improve the response time?

       

      Thanks

      Annick