Restructure is as fast as export, clear, load, calcOctober 7 2011 at 5:22 PM
No score for this post
|Cameron Lackpour |
from IP address 184.108.40.206
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.
- Re: Restructure is as fast as export, clear, load, calc - Javier on Oct 7, 8:17 PM
- Restructure is single threaded - John A. Booth on Oct 9, 1:40 PM