Batch Job Performance Issue.

[Former Member]

Hi Experts,

I am facing a performance issue in a background job, on a selection screen it contains month start date, end date and also effective date as 01/01/2008.

Client executing this report once in every month. Since the effective date is constant, the database contains large volume of data i.e. more than 3 lakh records Presently. Finally the job gets cancelled.

Could you please suggest what should be done in this scenario? Is there any concept like splitting the records as batches like multiples of 20 thousands.

Thanks and Regards,

Stanly

[Former Member]

hi

As you said you can split the records as packages. ( as teh issue is related to low memory of internal table )

select ....package size...

*-- program logic

endslect.

regards,

Naveen