Test script to check performance improvement with UNION ALL

Test script

<?php
/*
 * Test script to loop though get_user_access_sitewide()
 * for each user to get performance results with UNION ALL
 */

define('CLI_SCRIPT', true);
include_once("config.php");

// Max users to get access info of.
$MAX_USERS=64000;

$starttime = microtime(true);
// Loop though the users and get capabilities.
for($i=1; $i < $MAX_USERS; $i++) {
    if ($DB->record_exists('user', array('id'=>$i))) {
        get_user_access_sitewide($i);

        // Show progress.
        echo ".";
        if (($i % 70) == 0) {
            echo " " . $i . PHP_EOL;
        }
    }
}

$timetaken = microtime(true) - $starttime;
echo $timetaken . PHP_EOL;