I am am trying to selecting around 100 thousand records at a time and i am getting out of memory while running select adapter service. we need to transfer 3 million records at a time from DB to DB. i am worried about webmethods is not handling 100 thousands records, then how come for 3 million records.
I increased heap size
Any comments on this.