prompts in performance

[BIsrik]

if i have a choice of catalog prompt or file picklist prompt for a report. Which one should i choose for the report considering the performance issue. If so, please explain why should be that choice be...

Srik

[cognosfreelancer]

Srik

There is no hard and fast rule.

However I would lean very slightly towards a file picklist as a prompt source. The reason for this is that the file has been pre processed to arrive at the results.

Choosing a catalog picklist would mean a round trip to the database and this may sometimes add a couple of seconds of delay depending on the network congestion and database loads.

These seconds are very obvious when the user is tapping on the desk waiting for something to show up.

On the flip side I have found it more cumbersome to maintain reports with excessive file prompts.

HTH
NKT

[danimahesh]

I Prefer File Picklist as u can change the number of items listed in the file picklist which will be very helpfull while running the report.U can change the number of picklist  .u can do it in Impromptu.ini file file picklist =XXX.
after changing that u have to close and reopen the application so ,the effect will take place.

[Prad]

Hi There,

I will prefer file pick list. why becuase this is just a text file and where as the catalog prompt will use the catalog tables and in turn this filter will search the database tables for the matching values and then the out put is shown.

More over the file picklist is faster than the catalog picklist prompt.

Prad.