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
