Hi All,
I have created the straight table with 80 columns and 5 different expressions with 6 million records. So I gave options to the users to select at least one dimension and expression manually to see the data on the dashboard.
All the calculations for the expressions are done in the backend. Now I am trying to display data for one month with all the dimensions and expressions selected, which has around 100k rows of data.
My RAM capacity is 1TB and my application is using 250 GB RAM.
Even with the large amount of memory left in RAM, my application is taking forever to display.
Does anyone know what is causing this?
According to my knowledge, once aggregations are stored in RAM, it shouldn't take much time to display.
Please correct me, if I am wrong.
Thanks,
VK
