Reducing Processing time of large catalog/cubes over the network -
02-16-2005
, 11:31 AM
I have a catalog that we are do a full process on which consists of 7
cubes with about 75 millions rows of data(total). This catalog takes
about 6 hours when processed locally. Recently we moved our datamart
to another site(than the analysis server), now due to the data having
to travel a further distance across the network, it's taking 30 hours
to process, which is unacceptable.
Does anyone have any suggestions for decreasing the processing time due
to the network constraint? Currently I am doing the processing locally
and then archiving and copying the .cab file to the hosting server and
restoring it there. Deleting data is not an option. Please let me
know if you have any suggestions.
Thanks! |