0 Replies Latest reply: May 6, 2017 9:05 AM by Venkatesh botla RSS

    Performance issue in the front end

    Venkatesh botla

      Hi all,

       

      i am facing problem in the front end chart creation, charts are taking more time to reflect the data. 

      sample data is below

      tb:

      Load * inline

      [

         

      field,date,value,quality
      1,22-Mar,1,m
      1,25-Mar,2,k
      1,27-Mar,3,f
      1,22-Mar,3,f
      1,25-Mar,3,a
      1,27-Mar,4,d
      1,27-Mar,3,d
      2,25-Mar,4,f
      2,27-Mar,32,k
      2,27-Mar,2,dd
      2,20-Jan,2,d
      2,21-Jan,2,d
      2,22-Feb,2,m
      3,23-Mar,7,k
      3,2-Nov,66,f
      3,3-Nov,55,f
      3,3-Nov,44,m
      3,4-Nov,2,k
      3,4-Nov,2,f
      3,5-Dec,4,f
      3,5-Dec,6,m

      ];

      the above table is the data format of my data ,however in the reality all my field names are coming under field values like 1,2,3 .

       

      so i decided and converted whole data into fields by using generic load and used loop concept to stored all the tables formed under generic load as one table .so i got all my fields which under field column .

      That table i am using for my front analysis (However the data size is almost 9 GB)  

       

      Please suggest me a way to overcome this.

       

      Thanks

      Venkatesh