LASR TABLES PERFORMANCE

[vallsas]

Hi All,

Is there any link between LASR table size and VA performance, will it really impact if the size of the lasr table is high then totally va will down? or it will keep on slow till the table used in the desining reports?i think there is a possibility on too many users on same time but i have a case on only one user thught out the huge va system but it seems same response(very slow) ....any light on this? please..

[JuanS_OCS]

Hello @vallsas,

there is, indeed, a relationship, regarding performance.

I would suggest you to read the open thread at : https://communities.sas.com/t5/Administration-and-Deployment/calculate-memory-usage-or-free-space-in...

If you have further questions, we can continue from here 🙂

PS. You might also find this thread useful as well: https://communities.sas.com/t5/SAS-Visual-Analytics/Best-practices-to-control-data-Size-in-LASR/td-p...

[vallsas]

Many thanks 🙂

[AhmedAl_Attar]

Hi,

In addition to the answers you have got so far, I would recommend checking out the following link Sample 24804: %SQUEEZE-ing Before Compressing Data, Redux. Running your data sets through the %squeeze macro, could be a general good practice to control the overall disk space consumed by your SAS data sets, regardless whether you are uploading them to LASR or not. This approach does not have the CPU overhead that occurs when reading compressed data set.

Hope it helps,

Ahmed