We are using specific query flags to force the batch job to use temporary tables to calculate. It will make recalculation much slower, but will also make it virtually undetectable to the users that are in the Galleries at the time. crosses fingers

-Nicholas