Thursday 4 January 2007

Faster Update

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.

No comments: