How to get data from db in optimized way.

Hi All,

i am developing an application in whcih I have to fetch all the records from table. now the problem in doing so is while running the expression tule it's failing which i think is failing because  i am fetching everything at a time.

I want to fetch it in batches how can I make it in such a way that it fetch in batches but while writing, it should write it all at once. And also one thing this table will increase everyday by 5-7k rows.

And also if i fetch data in batches won't it hit db multiple times ? What should be preffered batch size ?

Please suggest me good practice to achieve the above.