3v4l.org

run code in 500+ PHP versions simultaneously
<?php $db = new PDO('sqlite::memory:'); $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $db->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC); $db->exec('CREATE TABLE example (name TEXT, vals TEXT);'); $insert = $db->prepare('INSERT INTO example (name, vals) VALUES (?, ?)'); $insert->execute(array('row1', '1,3,4')); $insert->execute(array('row2', '1')); $insert->execute(array('row3', '5,6')); function csv_intersection($vals, $search) { $vals_array = explode(',', $vals); $search_array = explode(',', $search); $intersection = array_intersect($vals_array, $search_array); return implode(',', $intersection); } $db->sqliteCreateFunction('intersection', 'csv_intersection', 2); $stmt = $db->prepare('SELECT name, vals FROM example WHERE intersection(vals, ?)'); $stmt->execute(array('1,2,3')); foreach ($stmt as $row) { var_dump($row); }

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).

VersionSystem time (s)User time (s)Memory (MiB)
8.5.70.0080.00917.89
8.5.60.0080.01019.62
8.5.50.0130.00617.67
8.5.30.0100.00922.31
8.5.20.0080.01020.36
8.5.10.0110.00617.44
8.5.00.0110.01120.66
8.4.220.0140.00620.42
8.4.210.0130.01220.39
8.4.180.0110.01420.57
8.4.170.0120.01222.57
8.4.160.0140.00924.86
8.4.150.0090.00417.36
8.4.140.0120.01118.27
8.4.130.0120.00919.45
8.4.120.0120.01018.49
8.4.110.0070.01525.08
8.4.100.0080.00618.52
8.4.90.0110.00921.70
8.4.80.0140.00619.68
8.4.70.0170.00518.61
8.4.60.0120.00820.39
8.4.50.0080.01220.40
8.4.40.0130.00320.27
8.4.30.0030.01718.45
8.4.20.0150.00621.29
8.4.10.0110.00718.44
8.3.310.0120.00921.04
8.3.300.0120.01019.25
8.3.290.0110.00921.47
8.3.280.0150.00620.89
8.3.270.0130.00817.35
8.3.260.0120.00917.41
8.3.250.0140.00717.39
8.3.240.0100.00717.72
8.3.230.0100.01117.45
8.3.220.0100.01019.75
8.3.210.0110.00917.64
8.3.200.0120.00917.38
8.3.190.0110.00817.52
8.3.180.0070.00317.30
8.3.170.0160.00317.63
8.3.160.0060.01217.31
8.3.150.0090.00921.50
8.3.140.0160.00317.33
8.3.130.0110.00017.71
8.3.120.0150.00319.57
8.3.110.0100.00620.94
8.3.100.0030.00624.06
8.3.90.0090.00326.77
8.3.80.0030.00619.06
8.3.70.0110.00719.05
8.3.60.0160.00019.30
8.3.50.0070.01018.14
8.3.40.0070.00719.73
8.3.30.0110.00419.65
8.3.20.0060.00322.60
8.3.10.0000.00822.59
8.3.00.0080.00021.56
8.2.310.0130.00718.89
8.2.300.0130.00922.92
8.2.290.0120.00917.43
8.2.280.0100.00519.14
8.2.270.0160.00318.17
8.2.260.0040.01119.10
8.2.250.0120.00919.56
8.2.240.0090.00017.99
8.2.230.0060.00322.58
8.2.220.0000.00937.54
8.2.210.0110.00426.77
8.2.200.0040.00719.04
8.2.190.0000.01521.02
8.2.180.0090.00619.17
8.2.170.0090.00622.96
8.2.160.0070.00723.01
8.2.150.0080.00024.18
8.2.140.0080.00024.66
8.2.130.0050.00326.16
8.2.120.0030.00521.87
8.2.110.0070.00321.90
8.2.100.0090.00319.02
8.2.90.0040.00419.22
8.2.80.0000.00918.80
8.2.70.0000.01018.66
8.2.60.0070.00318.84
8.2.50.0050.00518.38
8.2.40.0080.00020.23
8.2.30.0040.00419.97
8.2.20.0030.00618.78
8.2.10.0030.00520.23
8.2.00.0040.00420.11
8.1.340.0110.00922.46
8.1.330.0120.00817.05
8.1.320.0100.00917.16
8.1.310.0090.00017.68
8.1.300.0030.00619.13
8.1.290.0100.00030.84
8.1.280.0050.01025.92
8.1.270.0040.00421.49
8.1.260.0060.00326.35
8.1.250.0110.00728.09
8.1.240.0030.00721.77
8.1.230.0070.00321.85
8.1.220.0000.00818.54
8.1.210.0000.00919.38
8.1.200.0040.00418.11
8.1.190.0000.01018.10
8.1.180.0090.00018.41
8.1.170.0040.00419.25
8.1.160.0000.00819.56
8.1.150.0080.00019.69
8.1.140.0000.00823.05
8.1.130.0040.00420.94
8.1.120.0060.00318.16
8.1.110.0040.00418.35
8.1.100.0080.00018.28
8.1.90.0040.00418.28
8.1.80.0050.00318.15
8.1.70.0070.00318.27
8.1.60.0090.00018.45
8.1.50.0090.00018.38
8.1.40.0000.00818.41
8.1.30.0000.00818.55
8.1.20.0000.00818.51
8.1.10.0050.00318.35
8.1.00.0060.00318.30
8.0.300.0030.00620.39
8.0.290.0000.01017.50
8.0.280.0070.00019.43
8.0.270.0040.00417.60
8.0.260.0030.00319.32
8.0.250.0000.00817.87
8.0.240.0000.00917.82
8.0.230.0000.00717.77
8.0.220.0030.00617.80
8.0.210.0060.00317.77
8.0.200.0070.00017.89
8.0.190.0090.00017.80
8.0.180.0040.00417.73
8.0.170.0060.00317.74
8.0.160.0050.00217.70
8.0.150.0040.00417.61
8.0.140.0040.00417.59
8.0.130.0000.00614.18
8.0.120.0040.00417.69
8.0.110.0000.00817.66
8.0.100.0040.00417.63
8.0.90.0080.00017.73
8.0.80.0120.00817.76
8.0.70.0030.00517.51
8.0.60.0000.00817.60
8.0.50.0000.00817.84
8.0.30.0180.00018.03
8.0.20.0060.01517.85
8.0.10.0080.00017.94
8.0.00.0110.00917.66
7.4.330.0050.00015.78
7.4.320.0040.00417.46
7.4.300.0000.00717.31
7.4.290.0040.00417.28
7.4.280.0040.00417.45
7.4.270.0070.00017.44
7.4.260.0000.00717.21
7.4.250.0000.00817.32
7.4.240.0040.00417.47
7.4.230.0070.00017.21
7.4.220.0000.00817.29
7.4.210.0090.00817.48
7.4.200.0070.00017.49
7.4.160.0150.00417.21
7.4.140.0120.00817.86
7.4.130.0090.02117.51
7.4.120.0100.01317.35
7.4.110.0030.01617.32
7.4.100.0070.01317.41
7.4.90.0150.00617.07
7.4.80.0070.01119.39
7.4.70.0170.00717.35
7.4.60.0100.01317.31
7.4.50.0090.00517.09
7.4.40.0140.00317.38
7.4.00.0140.00315.57
7.3.330.0030.00314.16
7.3.320.0060.00013.98
7.3.310.0030.00317.15
7.3.300.0070.00017.09
7.3.290.0000.00717.05
7.3.280.0090.01317.11
7.3.260.0080.01317.21
7.3.240.0080.01117.28
7.3.230.0090.00917.11
7.3.210.0060.01317.45
7.3.200.0060.01217.40
7.3.190.0070.02117.30
7.3.180.0110.00717.31
7.3.170.0060.01617.45
7.3.160.0070.01117.23
7.3.00.0450.00815.56
7.2.330.0100.01017.54
7.2.320.0180.00617.37
7.2.310.0100.01017.51
7.2.300.0130.01017.33
7.2.290.0060.01617.66
7.2.130.0360.00715.59
7.2.120.0540.00915.81
7.2.110.0490.01115.77
7.2.100.0450.00615.63
7.2.90.0370.00715.65
7.2.80.0540.00715.88
7.2.70.0390.01015.61
7.2.60.0330.00915.45
7.2.50.0560.00715.44
7.2.40.0430.00715.55
7.2.30.0400.01415.63
7.2.20.0550.00915.74
7.2.10.0670.00615.58
7.2.00.0310.00715.91
7.1.250.0350.00714.75

preferences:
103.04 ms | 1418 KiB | 5 Q