Online PHP editor | perf for VL7UC

@ 2021-06-24T09:40:19Z

<?php
$db = new PDO('sqlite::memory:');

// These are the only reasonable settings to ever use:
$db->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

// Let's create a table:
$db->exec("CREATE TABLE foo (username TEXT, pwhash TEXT, email TEXT)");

// Dummy rows:
$db->exec("INSERT INTO foo(username, pwhash, email) VALUES ('scott',
'lolno', 'scott@paragonie.com')");
$db->exec("INSERT INTO foo(username, pwhash, email) VALUES ('robyn',
'fake!', 'robyn@paragonie.com')");

// Okay, now let's do a prepared statement, with an integer field
$int = 12345;

$stmt = $db->prepare("SELECT * FROM foo WHERE {$int} = ?");
$stmt->bindValue(1, $int, PDO::PARAM_INT);
$stmt->execute();
var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));

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.4.1	0.010	0.000	20.17
8.3.14	0.011	0.000	17.52
8.3.13	0.003	0.006	18.95
8.3.12	0.010	0.007	21.40
8.3.11	0.013	0.003	20.94
8.3.10	0.003	0.006	24.06
8.3.9	0.015	0.000	26.77
8.3.8	0.010	0.003	17.38
8.3.7	0.006	0.009	19.00
8.3.6	0.006	0.009	18.72
8.3.5	0.015	0.004	19.20
8.3.4	0.011	0.007	20.01
8.3.3	0.009	0.006	19.63
8.3.2	0.004	0.004	24.18
8.3.1	0.004	0.004	24.66
8.3.0	0.004	0.004	26.16
8.2.25	0.003	0.006	19.27
8.2.24	0.009	0.003	18.00
8.2.23	0.013	0.003	22.58
8.2.22	0.003	0.006	37.54
8.2.21	0.009	0.006	26.77
8.2.20	0.015	0.000	17.50
8.2.19	0.009	0.006	17.63
8.2.18	0.000	0.015	25.92
8.2.17	0.012	0.009	19.79
8.2.16	0.012	0.003	22.96
8.2.15	0.004	0.004	25.66
8.2.14	0.003	0.005	24.66
8.2.13	0.004	0.004	26.16
8.2.12	0.006	0.003	21.78
8.2.11	0.003	0.006	21.09
8.2.10	0.000	0.009	23.08
8.1.30	0.012	0.006	20.98
8.1.29	0.008	0.004	18.88
8.1.28	0.013	0.010	25.92
8.1.27	0.004	0.004	23.99
8.1.26	0.004	0.004	26.35
8.1.25	0.008	0.000	28.09
8.1.24	0.006	0.006	20.89
8.1.23	0.010	0.000	22.99
8.0.7	0.010	0.010	17.71

preferences:dark modelive preview