Re: question

In article <3qqgri$db2_at_eccdb1.pms.ford.com> alal1_at_PROBLEM_WITH_INEWS_GATEWAY_FILE (Anuj Lal) writes:
>From: alal1_at_PROBLEM_WITH_INEWS_GATEWAY_FILE (Anuj Lal)
>Subject: question
>Date: 3 Jun 1995 20:31:46 GMT
 

>
>I am fetching around 100000 rows from remote database through some
>user exit and do some processing in user exit which reduces the number of
>rows to 2000 , which I have to display on screen.
>Because of transfering all rows across the network make the performance
>very bad. Is there any way I can call the some procedure residing
>on remote server which do all processing and then send the
>processed row back to my user exit. Any help regarding how to
>make RPC call to remote server and Then Tx the result back to
>my application through another RPC call.
 

>Thanks
>alal1_at_eccdb1.pms.ford.com

You best solution would be to eliminate those excess rows with your where clause. I'd start there. Otherwise you can have a persistent stored procedure on the server and do the processing there. keep calling it to fetch the 2000 rows until it doesn't have any more. Received on Thu Jun 08 1995 - 00:00:00 CEST