We have one time activity where we need to select around 50-30 thousand rows or more from one table … and based on the result update certain fields in another table. and update will also be same no as insert.
Just want to know will loading such large amount of data at one go can be done by wM
(Had the no of rows been less then it would have been done using two adapter services , select and update)
Can anyone suggest me a better and faster method.