# Change line 44 inside init_wb
$wb->sheets($_)->set_column(0, 4, 15, $center);
# To this
$wb->sheets($_)->set_column(0, 19, 15, $center);
####
# Replace the if/elsif block inside mce_loop with the following
# Fill worksheet rows/cells
if ($region eq 'AMS') {
$wb = init_wb(0); $ws = $wb->sheets(0);
$ws->write(0, 2, 'foo', $format);
for my $row (1..1e6) { for my $cell (0..19) {
$ws->write($row, $cell, $row + $cell + 10e6);
}}
print "AMS ---- DONE.\n";
}
elsif ($region eq 'APJ') {
$wb = init_wb(1); $ws = $wb->sheets(1);
$ws->write(0, 2, 'bar', $format);
for my $row (1..1e6) { for my $cell (0..19) {
$ws->write($row, $cell, $row + $cell + 20e6);
}}
print "APJ ---- DONE.\n";
}
elsif ($region eq 'EMEA') {
$wb = init_wb(2); $ws = $wb->sheets(2);
$ws->write(0, 2, 'baz', $format);
for my $row (1..1e6) { for my $cell (0..19) {
$ws->write($row, $cell, $row + $cell + 30e6);
}}
print "EMEA ---- DONE.\n";
}
####
$ time perl write_60mil.pl
AMS ---- DONE.
EMEA ---- DONE.
APJ ---- DONE.
Node List is Done.
real 4m35.239s
user 12m 3.641s
sys 0m 4.242s
####
# update /etc/fstab
tmpfs /dev/shm tmpfs defaults,size=5g 0 0
# afterwards, remount /dev/shm
mount -o remount /dev/shm