BookmarkSubscribeRSS Feed
FrankE
Fluorite | Level 6
Hi guys, I wrote a stored process which takes a dynamic paramter, account number. Each night in our batch process I create a SAS dataset which conatins a row for each distinct account and the associated name and I then use this table to build the dynamic prompt values. (there's about 15k rows).

My issue is that when I try to load this stored process in the stored process web app performance is pretty slow when loading this dynamic prompt. Is there anything I can do to speed things up? I saw some mention of a limit I can set on the number of rows loaded in the prompt but I can't seem to find where to set this....

Thanks!
2 REPLIES 2
SAS_Doctor
Calcite | Level 5
Do the users need to see all 15K of data? I would think you need to limit the amount of data that the prompt shows. If it is, it sounds like the same issue I am having. Maybe you could create a view of the table/file and then use the view as the source for the prompt just showing the subset?
FrankE
Fluorite | Level 6
The users need to be able to search through all 15k records but I don't want them loading as part of the page. I assumed that SAS would be smart enough to make these prompts work with AJAX so they dynamically load the records as the user types in the box. (like Google) (see this paper: http://support.sas.com/resources/papers/proceedings10/014-2010.pdf)

I've done everything I can think of to speed performance.. I cut the dataset down to only the fields required by the promt and indexed it.. still not very good performance. I hope SAS has some sort of solution for this as its a real deal breaker for being able to use their products over a home-grown solution.

sas-innovate-2024.png

 

Secure your spot at the must-attend AI and analytics event of 2024: SAS Innovate 2024! Get ready for a jam-packed agenda featuring workshops, super demos, breakout sessions, roundtables, inspiring keynotes and incredible networking events.

 

Register by March 1 to snag the Early Bird rate of just $695! Don't miss out on this exclusive offer. 

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 848 views
  • 0 likes
  • 2 in conversation