Desktop productivity for business analysts and programmers

Performance issues in SAS Infomation Map

Reply
Super Contributor
Posts: 350

Performance issues in SAS Infomation Map

Hi,

 

Recently we have upgraded SAS from 9.2 to 9.4 after that we are facing performance issues in information maps while running in SAS EG.

When I run the query in DB is runs faster.

When I run the query in SAS stored process it runs faster,but when I run the infomap which is build on SAS Stored process it is taking time and the same information maps were running fine in sas 9.2 version.

 

I enable the trace to check where exactly the issue is.

 

  1. Information map log -----  The fetch time in seconds for 1000 rows
  2. After changing the readbuff to 3000 ---- The fetch time in seconds for 3000 rows---It runs faster.

libname _egimle sasioime

62               mappath="/Information Maps"

63               aggregate=yes

64               metacredentials=no

65               PRESERVE_MAP_NAMES=YES readbuff=3000

 

I have checking where can I change the default readbuff size in sas information map studio so that all infomaps runs faster or I missing some thing please advise?

 

Thanks,

Shivas

Ask a Question
Discussion stats
  • 0 replies
  • 182 views
  • 0 likes
  • 1 in conversation