This Essbase discussion board is provided as a free service and dedicated to all the Essbase professionals out there!
 Return to Index  

Restructure is as fast as export, clear, load, calc

October 7 2011 at 5:22 PM
No score for this post
Cameron Lackpour 
from IP address 71.162.226.73


Response to Re: Page size increase when clearing blocks

Or even full export, clear, and load.

It's really weird (or at least nonintuitive) as the restructure is single threaded and the export/import can be set to work in parallel.

At least that's been my observation -- I haven't tested it out yet on many databases but for three of them at least, it is a complete wash (and this includes an export and then a restructure). I'd be interested to hear if others have seen differently.

Regards,

Cameron Lackpour

 
Scoring disabled. You must be logged in to score posts.Respond to this message   
Responses

  1. Re: Restructure is as fast as export, clear, load, calc - Javier on Oct 7, 8:17 PM
    1. Restructure is single threaded - John A. Booth on Oct 9, 1:40 PM
     

RSS feed for this forum - http://www.network54.com/Forum/58296?xml=rss. Please email hypess (at) gmail.com, if you have any questions/feedback/issues.