Posted by [IP Address: 162.95.80.197] 'ShuSheng Li' on August 29, 2001 at 14:46:32 EST:

Hi:

I am working on a problem on one of our custom prompt table: the data listed in the prompt table is from a view (of course) and it returns about 20,000 rows, it takes long time to transfer the 20,000 rows from server to the client. I can't change the SQL of the view unless the view can accept parms as part of its where clause (and I don't know if this is possible on PeopleSoft). Can anyone point me a direction on how to handle this? or if there is a way to modify the process of loading the prompt/edit table?

Any advise is deeply appreciated.

Shusheng Li

Follow Ups:

• Re: Limit number of records in a prompt table Todd 15:24:52 8/29/01 EST (7)
  • Re: Limit number of records in a prompt table ShuSheng Li 18:43:45 8/29/01 EST (6)
    • Re: Limit number of records in a prompt table remotedeveloper 08:37:34 8/30/01 EST (4)
      • Re: Limit number of records in a prompt table ShuSheng Li 12:16:52 8/30/01 EST (3)
        • Re: Limit number of records in a prompt table remotedeveloper 17:32:41 9/04/01 EST (0)
        • Re: Limit number of records in a prompt table Todd 12:44:48 8/30/01 EST (1)
          • Re: Limit number of records in a prompt table ShuSheng Li 13:18:22 8/30/01 EST (0)
    • Re: Limit number of records in a prompt table remotedeveloper 08:37:26 8/30/01 EST (0)

Post a Followup