3v4l.org

run code in 300+ PHP versions simultaneously
<?php echo "SELECT s.SEQSIT as ID, " . "s.GEOMETRY.get_wkt() AS POLY " . "FROM TRANPOST.SITE s " . "WHERE s.GEOMETRY.get_wkt() IS NOT NULL " . "AND SDO_RELATE(s.GEOMETRY, " . "2003, NULL, NULL, " . "SDO_ELEM_INFO_ARRAY(1,1003,3), " . "SDO_ORDINATE_ARRAY(:LatNE,:LongNE,:LatSW,:LongSW)), " . "'mask=anyinteract') = 'TRUE'";

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.3.60.0090.00618.18
8.3.50.0070.01221.20
8.3.40.0140.00018.75
8.3.30.0000.01320.39
8.3.20.0040.00420.25
8.3.10.0040.00422.14
8.3.00.0060.00322.40
8.2.180.0110.01118.29
8.2.170.0100.00722.96
8.2.160.0070.00720.43
8.2.150.0040.00424.18
8.2.140.0140.00424.66
8.2.130.0070.00726.16
8.2.120.0030.00619.54
8.2.110.0030.00622.19
8.2.100.0060.00619.34
8.2.90.0060.00319.09
8.2.80.0020.00519.21
8.2.70.0050.00517.49
8.2.60.0090.00017.91
8.2.50.0030.00618.07
8.2.40.0060.00318.02
8.2.30.0040.00417.80
8.2.20.0080.00017.45
8.2.10.0080.00017.60
8.2.00.0050.00217.50
8.1.280.0070.00725.92
8.1.270.0030.00524.66
8.1.260.0070.00026.35
8.1.250.0040.00428.09
8.1.240.0090.00023.91
8.1.230.0040.00719.11
8.1.220.0040.00417.74
8.1.210.0000.00818.77
8.1.200.0050.00517.23
8.1.190.0040.00417.40
8.1.180.0030.00520.25
8.1.170.0030.00618.59
8.1.160.0030.00522.18
8.1.150.0040.00418.51
8.1.140.0050.00217.36
8.1.130.0070.00017.76
8.1.120.0000.00717.32
8.1.110.0030.00517.37
8.1.100.0040.00417.33
8.1.90.0000.00817.21
8.1.80.0000.00717.23
8.1.70.0000.00717.28
8.1.60.0040.00417.46
8.1.50.0000.00717.23
8.1.40.0040.00417.42
8.1.30.0000.00917.50
8.1.20.0030.00617.52
8.1.10.0030.00517.47
8.1.00.0060.00317.25
8.0.300.0040.00418.77
8.0.290.0070.00017.18
8.0.280.0030.00518.30
8.0.270.0000.00717.06
8.0.260.0000.00816.75
8.0.250.0000.00716.85
8.0.240.0080.00016.79
8.0.230.0070.00016.72
8.0.220.0000.00716.75
8.0.210.0030.00316.80
8.0.200.0080.00016.84
8.0.190.0070.00016.71
8.0.180.0000.00716.76
8.0.170.0000.00716.82
8.0.160.0030.00316.64
8.0.150.0000.00716.61
8.0.140.0070.00016.74
8.0.130.0000.00513.20
8.0.120.0060.00316.82
8.0.110.0030.00316.65
8.0.100.0040.00416.57
8.0.90.0000.00716.64
8.0.80.0120.00316.73
8.0.70.0070.00016.64
8.0.60.0040.00416.83
8.0.50.0040.00416.81
8.0.30.0110.00716.92
8.0.20.0130.01017.40
8.0.10.0040.00416.72
8.0.00.0140.00616.74
7.4.330.0000.00615.00
7.4.320.0000.00616.32
7.4.300.0000.00716.44
7.4.290.0030.00316.40
7.4.280.0000.00716.36
7.4.270.0030.00316.37
7.4.260.0030.00316.46
7.4.250.0000.00716.27
7.4.240.0020.00516.35
7.4.230.0070.00016.47
7.4.220.0120.00616.34
7.4.210.0100.00416.38
7.4.200.0070.00016.13
7.4.190.0000.00816.61
7.4.160.0110.00716.42
7.4.150.0090.01317.40
7.4.140.0060.01117.86
7.4.130.0080.00816.37
7.4.120.0150.00116.45
7.4.110.0120.00916.44
7.4.100.0100.00716.52
7.4.90.0060.01016.29
7.4.80.0120.00419.39
7.4.70.0070.01116.38
7.4.60.0060.00916.45
7.4.50.0020.00216.21
7.4.40.0060.01022.77
7.4.30.0110.00916.46
7.4.00.0060.00915.12
7.3.330.0020.00213.07
7.3.320.0000.00613.04
7.3.310.0000.00715.99
7.3.300.0000.00716.12
7.3.290.0140.00016.10
7.3.280.0090.00716.14
7.3.270.0090.00917.40
7.3.260.0170.00716.36
7.3.250.0080.01016.42
7.3.240.0100.00716.14
7.3.230.0190.00316.39
7.3.210.0130.00316.34
7.3.200.0110.01219.39
7.3.190.0150.00716.10
7.3.180.0090.00616.15
7.3.170.0060.00916.27
7.3.160.0040.01816.13
7.3.120.0040.01114.89
7.2.330.0090.00916.21
7.2.320.0130.00616.29
7.2.310.0130.01016.39
7.2.300.0090.00916.42
7.2.290.0040.01416.36
7.2.00.0060.00618.81
7.1.100.0060.00617.87
7.1.70.0000.01116.67
7.1.60.0060.01319.29
7.1.50.0110.01116.70
7.1.00.0030.05322.57
7.0.200.0770.00714.69
7.0.140.0070.07022.00
7.0.70.5200.03019.91
7.0.60.0000.06319.92
7.0.50.0000.05017.75
7.0.40.0130.05720.09
7.0.30.0270.08020.30
7.0.20.0400.05320.01
7.0.10.0230.05320.20
7.0.00.0030.06020.30
5.6.280.0030.07320.85
5.6.210.0000.09020.59
5.6.200.0100.08018.18
5.6.190.0070.08720.54
5.6.180.0230.06020.23
5.6.170.0170.04020.49
5.6.160.0030.04020.51
5.6.150.0100.07318.22
5.6.140.0000.04318.14
5.6.130.0000.08718.12
5.6.120.0070.07021.00
5.6.110.0130.07721.00
5.6.100.0100.07320.88
5.6.90.0070.04720.96
5.6.80.0130.07720.36
5.6.70.0170.08020.40
5.5.350.0070.08020.40
5.5.340.0100.07017.84
5.5.330.0030.07320.21
5.5.320.0030.06720.38
5.5.310.0270.06320.33
5.5.300.0030.04017.88
5.5.290.0070.04717.95
5.5.280.0030.08720.77
5.5.270.0000.04320.95
5.5.260.0100.04020.75
5.5.250.0100.08020.68
5.5.240.0130.07320.25
5.4.450.0270.06719.61
5.4.440.0100.05719.59
5.4.430.0800.05319.60
5.4.420.0830.04019.46
5.4.410.0100.05019.34
5.4.400.0600.05719.15
5.4.390.0270.05319.19
5.4.380.0300.07018.44
5.4.370.0100.03718.47
5.4.360.0100.04018.69
5.4.350.0100.04211.97
5.4.340.0100.06111.97
5.4.320.0070.03612.46
5.4.310.0090.04412.45
5.4.300.0030.03912.45
5.4.290.0120.03412.45
5.4.280.0070.04112.35
5.4.270.0040.04112.31
5.4.260.0080.04412.31
5.4.250.0070.04112.32
5.4.240.0050.03812.32
5.4.230.0060.03812.32
5.4.220.0050.03712.31
5.4.210.0060.03512.31
5.4.200.0070.03612.31
5.4.190.0060.04212.31
5.4.180.0040.03812.31
5.4.170.0070.03612.32
5.4.160.0050.03612.31
5.4.150.0050.03612.31
5.4.140.0070.04012.00
5.4.130.0050.03911.98
5.4.120.0070.03511.94
5.4.110.0050.03711.94
5.4.100.0060.03511.94
5.4.90.0050.03911.94
5.4.80.0060.03711.94
5.4.70.0050.04011.93
5.4.60.0070.03911.93
5.4.50.0080.03711.93
5.4.40.0070.03511.92
5.4.30.0070.03611.92
5.4.20.0050.03611.92
5.4.10.0060.03311.92
5.4.00.0060.03711.41
5.3.290.0080.05212.80
5.3.280.0060.03912.71
5.3.270.0060.04112.72
5.3.260.0100.03812.72
5.3.250.0050.03912.72
5.3.240.0050.03812.72
5.3.230.0090.04012.71
5.3.220.0070.04112.68
5.3.210.0070.04412.68
5.3.200.0080.04112.68
5.3.190.0080.03712.68
5.3.180.0050.03812.67
5.3.170.0050.03712.67
5.3.160.0080.03512.67
5.3.150.0070.03912.67
5.3.140.0070.03612.66
5.3.130.0060.03812.66
5.3.120.0080.03812.66
5.3.110.0050.04112.66
5.3.100.0070.03512.12
5.3.90.0070.03612.08
5.3.80.0070.03712.07
5.3.70.0060.03612.08
5.3.60.0040.03812.07
5.3.50.0050.03912.00
5.3.40.0050.03912.00
5.3.30.0050.03811.94
5.3.20.0070.03611.71
5.3.10.0070.03511.67
5.3.00.0050.03611.65

preferences:
53.05 ms | 401 KiB | 5 Q