straight table is loading slow

[pawwy1415]

Hi Everyone,

Can any one please help me on how to increase the straight table performance to load quickly.

In Straight Table i have total 17 Dimensions and 1 expression with 1523 rows.

I have moved the calculated dimensions to back end script and called direct fields in the straight table but still there is 5 secs lag.

Once thing i didn't understand is when i have opened the app for the first time i am facing this lag after that when i have opened the app again not finding this lag.

Please let me know  is there any other ways to increase the performance.

Thanks in advance.

[raji6763]

hi @pawwy1415 ,

• if you use any key field in table,you can remove the key field that will slowdown your  table.
• load only 2 years of data instead of load 6  years of data (limit your  data).
• user first need to perform some selection then only straight table data will be visible. This is the best way to do overcome this issue as you are filtering the table data before the  table data presented to the user.
• Avoid calculated dimension if you are using it. do the  all calculation to script itself.
• you will increase RAM size .

regards,

raji