Performance of Reports - PowerPrompts

[cogjai]

Hi:
We are going to create powerprompts applications for web users of Impromptu reports. We are removing the prompts and filter from the original impromptu report. We are designing the powerprompt application for this report with the user required prompts. We are passing the prompts to the impromptu report, where data will be filtered according to user selected prompts. We are in doubt about the performance of reports(Report returning time).

1. Will there be any degradation of performance, since we need to run powerprompt application and subsequently the request should go to impromptu report.
or
2. Will there be any performance improvement if we use powerprompt because of one reason or the other.
or
3. There will not be any change in performance.

thanks in advance

 

[rcaesar]

We have been using power prompts for a while.
Some points here:

We did not use dynamos, but used javaScript for the PP.

If you index some of the prompt values (eg. Manager Name) it tends to be faster.

We did some time estimates, most prompts (4 prompts to an IWR) takes about 1-2 min. depending on the sql passed and the result set.

Then of course the IWR is still there to run.

We are not happy with the speed, but there seem to few other options if you want the look, felexibility etc that PPs offer.

Also, you might want to check your middle ware if you are using one. We use neon client, which is single threaded, and that could actually be causing the prob.
Hope that helps