BookmarkSubscribeRSS Feed
sushil
Calcite | Level 5

- In dashboard we have interaction, bar charts and table. The table is in lasr  has 160 million record and 30 column. Out of 30 column 24 columns are character and 6 columns are numeric. 24 column also includes user name (lets assume tom, sam etc). Lets assume out of 160 million, 4000 records are of SAM, 10000 records are of tom.


- Sam login from web portal and will see dashboard that he is suppose to see based on access set in above table. Interaction, charts response time is fast but to display 4000 records in table in dashboard is taking a long time.  The dashboard will be accessed concurrently by many users and is dynamic ( Today SAM has 4000 records after 2 days SAM may have 3500 records)


- How to we increase the the response time of displaying table in dashboard? We tried reducing the length of character column but didn't helped much.


Any other approach that can be tried to increase response time of displaying table in dashboard?



3 REPLIES 3
souyoong21st
Calcite | Level 5

I think it's best that you lodge a support ticket with SAS because performance can be depended on number of things and one of them would be your IT infrastructure, network setup

You may need webex to show them the exact detail and also prepare to transfer the file

PeterWijers
Lapis Lazuli | Level 10

Hi there,

please consider to split up your list table in multiple list tables.

start on the left side with one of the most common report fields.

So this table will contain only several records.

put  more list tables to the right and link them from left to right.

fill the other list tables with more indepth report fields.

no the user automaticaly makes pre-selections from left to right,

filtering and speeding-up the performance.

works for me....

greetings, Peter

Explore_SAS
Obsidian | Level 7

I guess you might have to scale up underlying hardware...might have to add more nodes in LASR.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 3 replies
  • 1114 views
  • 0 likes
  • 4 in conversation