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)