| 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 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 |
| Responses- 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
|
|
|