dbTalk Databases Forums  

Is there a way to merge a temp partition to the cube faster?

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Is there a way to merge a temp partition to the cube faster? in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Polaris
 
Posts: n/a

Default Is there a way to merge a temp partition to the cube faster? - 08-26-2003 , 02:44 PM






Hi:

I'm process a cube by Incremental Update (using DSO), in which a temp
partition is created, processed and then merged with cube's default
partition. I found out that the time taken to merge is quite long. Any one
knows how to speed up the merge? For example, is it possible to process the
temp partition in RAM and then merge with the cube's default partition? Or
pre-allocate enough disk space for the cube's default parttition so that
there will be no phyisical space merge later when a temp partition is merged
with it's cube? Just my guess, do not know if OLAP provide such flexibility.

Thanks for your info



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.