If you have an update which is taking a long time even when you do it via forall:
- copy the update procedure a few times, depending on how many cpu are available.
- modify each of the above to update a portion of the table.
- run the above copied procedure in parallel.
So if your total update takes 4 hours, and you break the code into 4 each working on a range of the data, then this will reduce the update to 1 hour.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment