performance issue for dowloading PIR records to appln server.

i am downloading the PIR records to the application server.

the program is running fine .

i m using background coz i m downloading large no of records (>5000)

my actually target is 28000 records. we are spliting it up into atleast 7000 records at a time.

for 1000 records , it is taking 217 secs (this is fine)

for 2000 records , it is taking 1647 secs (not satisfactory)

for 5130 records , it is crossed more than 10647 secs still running (not acceptabe)

why is it increasing in expotenial of time for increase in the records

why not ~1000 sec for 5130 records...??

somebody help me , the hav check the extended check and fine tuned the code.

it is a modification of standard program RM06IBIE for download of PIR records.

regards

venkat.