Online PHP editor | perf for 5Jr3N

@ 2022-07-26T15:01:53Z

<?php
// Create connection
$start = microtime(TRUE);
error_log('Connecting');
$connection=mysqli_connect("localhost","******","*****","*****");
error_log('Connection took' . microtime(TRUE) - $start);
// Check connection
if ($connection == false) {
    die("ERROR: Could not connect. " .mysqli_connect_error());
}
// This SQL statement selects ALL from the table 'Locations'
$sql = "SELECT * FROM Notes";
error_log('Running select');
if ($result = mysqli_query($connection, $sql)){
    error_log('Select took' . microtime(TRUE) - $start);
    // If so, then create a results array and a temporary one
    // to hold the data
    $resultArray = array();
    // Loop through each row in the result set
    error_log('looping fetch');
    while($row = $result->fetch_object())
    {
        error_log('Fetch is running at ' . microtime(TRUE) - $start);
        // Add each row into our results array
        $resultArray[] = $row;
    }
    // Finally, encode the array to JSON and output the results
    echo json_encode($resultArray);
}
error_log('Fetch is done at ' . microtime(TRUE) - $start);
// Close connections
mysqli_close($connection);
error_log('Connection closed at ' . microtime(TRUE) - $start);
?>

Here you find the average performance (time & memory) of each version. A grayed out version indicates it didn't complete successfully (based on exit-code).

Version	System time (s)	User time (s)	Memory (MiB)
8.1.8	0.009	0.003	17.28
8.1.7	0.005	0.005	17.41
8.1.6	0.010	0.005	17.46
8.1.5	0.013	0.004	17.50
8.1.4	0.007	0.003	17.43
8.1.3	0.015	0.003	17.63
8.1.2	0.018	0.000	17.60
8.1.1	0.011	0.006	17.58
8.1.0	0.003	0.015	17.42
8.0.21	0.007	0.007	16.74
8.0.20	0.015	0.000	16.95
8.0.19	0.015	0.000	16.89
8.0.18	0.012	0.004	16.88
8.0.17	0.008	0.006	16.79
8.0.16	0.007	0.007	16.79
8.0.15	0.012	0.004	16.76
8.0.14	0.012	0.003	16.88
8.0.13	0.010	0.006	16.81
8.0.12	0.004	0.007	16.86
8.0.11	0.007	0.007	16.80
8.0.10	0.011	0.004	16.70
8.0.9	0.014	0.000	16.86
8.0.8	0.006	0.008	16.81
8.0.7	0.016	0.000	16.78
8.0.6	0.011	0.004	16.76
8.0.5	0.013	0.000	16.84
8.0.3	0.011	0.006	16.79
8.0.2	0.011	0.004	16.84
8.0.1	0.016	0.000	16.91
7.4.30	0.014	0.003	16.51
7.4.29	0.011	0.000	16.45
7.4.28	0.015	0.004	16.61
7.4.27	0.008	0.005	16.60
7.4.26	0.013	0.006	16.47
7.4.25	0.007	0.004	16.56
7.4.24	0.008	0.004	16.60
7.4.23	0.012	0.008	16.40
7.4.22	0.013	0.004	16.39
7.4.21	0.010	0.007	16.41
7.4.20	0.008	0.008	16.51
7.4.19	0.016	0.000	16.66
7.4.18	0.006	0.006	16.51
7.4.16	0.013	0.000	16.60
7.4.15	0.005	0.005	16.37
7.4.14	0.000	0.011	16.43
7.4.13	0.011	0.004	16.37
7.4.12	0.010	0.005	16.43
7.4.11	0.005	0.005	16.49
7.4.10	0.009	0.006	16.42
7.4.9	0.010	0.007	16.45
7.4.8	0.012	0.004	16.49
7.4.7	0.007	0.007	16.33
7.4.6	0.004	0.009	16.34
7.4.5	0.009	0.003	16.38
7.4.4	0.006	0.006	16.45
7.4.3	0.005	0.006	16.45
7.4.2	0.005	0.005	16.48
7.4.1	0.012	0.000	16.35
7.4.0	0.005	0.005	16.38

preferences:dark modelive previewkey bindings