Dynamic prompt performance tuning?

[FrankE]

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!

[SAS_Doctor]

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]

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.