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!