R
Rob Fitzpatrick
Guest
Today I have been doing a little testing of proutil bigrow on various platforms in 11.6.0 and 11.6.3. The results aren't what I expect. The test: - create a sports DB - set BI cluster size to 32 GB - bigrow to add another 4 clusters (writing 256 MB total to BI) - delete database I expect this to be fast in 11.6 due the changes made in 11.3 that the BI writes for bigrow should be buffered. I tested on each platform both with and without -zextendSyncIO. Results, in seconds, on Server 2012 R2 Datacenter (11.6.3, VM, SAN storage): default: 26 25 25 with -zextendSyncIO: 26 26 25 Results on RHEL 6.3 (11.6.3, bare metal, local disks): default: 9.14 8.54 7.25 9.55 with -zextendSyncIO: 9.07 9.88 9.78 Results on AIX 7.1.0.0 (11.6.0, bare metal, SAN storage): default: 1.15 1.05 0.93 with -zextendSyncIO: 16.54 14.28 13.54 On AIX, the difference with and without -zextendSyncIO is dramatic, and is what I expect based on my understanding of the 11.3 enhancement. On Windows and Linux I see no significant differences. Does anyone else see these platform differences? Or do you have different results you can share? Should this work the same on all platforms?
Continue reading...
Continue reading...