topic Re: VA Slowness issue in SAS Visual Analytics

VA Slowness issue

sht — Sat, 07 May 2016 05:35:57 GMT

Hi Team,

Greetings for the day!!!....

I am facing issue while opening any report in VA Viewer. Report takes too much time to open.

Can you please tell me what can be the reasons and how to resolve this.

Thanks....

Re: VA Slowness issue

MichelleHomes — Sat, 07 May 2016 05:59:17 GMT

There could be many reasons for this... Please provide some details relating to your environment:

What version of SAS Visual Analytics are you using?
Are you using the Modern or Classic Viewer
What content does your report contain? ie/ how many sections, report objects etc is it running stored processes
What browser are you using and what version
do you get a time-out or any messages?
How long does it take to load? What is your definition of "too much time"?
If using the Classic viewer what version of Adobe Flash do you have installed?

Here are a few support notes you can have a look at:

Please also first search this SAS Visual Analytics community as there have been previous discussions on this topic too such as https://communities.sas.com/t5/SAS-Visual-Analytics/Huge-speed-difference-between-modern-and-classic/m-p/257713#M3631

Kind Regards,

Michelle

Re: VA Slowness issue

sht — Sat, 07 May 2016 06:46:18 GMT

Hi Michelle,

Version of VA is 7.3

Viewer is classic

There are no stored processes but sections are maximum 4 and each section contains contains 3-4 report objects and 3-4 filters.

Browser is Internet Explorer 11

Sometimes I get message like 'Report is taking time to open Do you want to continue?'

It is taking more than 30 seconds to open report

Thanks

Re: VA Slowness issue

TriciaAanderud — Sat, 07 May 2016 09:51:12 GMT

Michelle is on the right track. Allow me to just add that I've seen that message in these circumstances:

-The underlying dataset was large and took a long time to render. As a test you can pre-filter it. For instance, if the data has 20 products, just limit it to 1 to see if that influences the time.

-Another time we had some hardware that was starting to fail. This is less likely to be the cause but is something to be aware of.

Re: VA Slowness issue

sht — Sat, 07 May 2016 10:13:41 GMT

Hi Tricia,

Thanks for reply.
Size of table is large its above 4gb, but data is already filtered.
Is there any other setting by which speed will be enhanced.

Thanks

Re: VA Slowness issue

MichelleHomes — Sat, 07 May 2016 10:51:35 GMT

Thanks for describing your environment.

There is a known issue with large SAS Visual Analytic reports performing poorly as described at http://support.sas.com/kb/56/894.html You may want to try the test suggested in the note and apply the hotfix if it applies to your situation.

Kind Regards,

Michelle

Re: VA Slowness issue

TriciaAanderud — Sat, 07 May 2016 10:51:56 GMT

I don't think 4GB is exceptionally large. The dataset we were using was well over 16 GB on a non-distributed server.

Check if the LASR server has any data that can be removed so your dataset has more space to work. Many times I see people load multiple copies of the same dataset with a few minor changes. They don't remove the downlevel datasets - so you will see Test_data_V1, Test_Data_v2, Test_data_v3, etc.

You might see if you can reduce the size of the dataset.

Reduce the size of the character fields. Use PROC CONTENTS to review the length. For instance, we had a field that had survey responses that was set to a length of 50 and the responses were "Yes" and "No". We reset that size to 8.

Can any columns be removed? For instance, some people have multiple date fields and the only difference is the formatting. Here's a blog post where I talk about how to duplicate the values and use formatting inside SAS VA.

We were able to reduce the dataset size nearly in half using this techniques.