dbTalk Databases Forums  

Reducing Processing time of large catalog/cubes over the network

comp.databases.olap comp.databases.olap


Discuss Reducing Processing time of large catalog/cubes over the network in the comp.databases.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
mitchchristensen@yahoo.com
 
Posts: n/a

Default 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!


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.