3v4l.org

run code in 300+ PHP versions simultaneously
<?php echo "SELECT s.SEQSIT as ID, " . "s.GEOMETRY.get_wkt() AS GEOM, " . "c.color as color, c.linestyle as line " . "FROM TRANPOST.SITE s, " . "tranref.trangis_symbology_catalog c " . "WHERE c.seqlif = s.seqlif " . "AND s.GEOMETRY.get_wkt() IS NOT NULL " . "AND SDO_RELATE(s.GEOMETRY, " . "SDO_GEOMETRY (2003, 327680, NULL, " . "SDO_ELEM_INFO_ARRAY(1,1003,3), " . "SDO_ORDINATE_ARRAY(:LatSW,:LongSW,:LatNE,:LongNE)), " . "'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.0100.01018.20
8.3.50.0110.00517.47
8.3.40.0110.00418.67
8.3.30.0160.00018.51
8.3.20.0030.00518.44
8.3.10.0090.00020.43
8.3.00.0150.00019.26
8.2.180.0070.01016.50
8.2.170.0140.00322.96
8.2.160.0070.00722.08
8.2.150.0100.00624.18
8.2.140.0120.00624.66
8.2.130.0070.00326.16
8.2.120.0000.00719.89
8.2.110.0030.00720.19
8.2.100.0080.00417.91
8.2.90.0090.00019.22
8.2.80.0080.00017.97
8.2.70.0030.00617.25
8.2.60.0050.00217.92
8.2.50.0050.00518.07
8.2.40.0040.00418.03
8.2.30.0060.00317.95
8.2.20.0000.00717.47
8.2.10.0000.00717.49
8.2.00.0000.00717.49
8.1.280.0040.01825.92
8.1.270.0000.00723.99
8.1.260.0040.00426.35
8.1.250.0040.00428.09
8.1.240.0060.00322.19
8.1.230.0080.00417.42
8.1.220.0050.00317.74
8.1.210.0080.00018.77
8.1.200.0000.01017.23
8.1.190.0050.00217.27
8.1.180.0040.00418.10
8.1.170.0050.00318.77
8.1.160.0000.00818.84
8.1.150.0040.00418.57
8.1.140.0000.00717.23
8.1.130.0000.00717.30
8.1.120.0040.00417.37
8.1.110.0000.00817.25
8.1.100.0050.00317.39
8.1.90.0000.00717.38
8.1.80.0020.00517.32
8.1.70.0000.00717.36
8.1.60.0000.00817.46
8.1.50.0000.00817.40
8.1.40.0040.00417.39
8.1.30.0000.00717.42
8.1.20.0000.00817.40
8.1.10.0040.00417.46
8.1.00.0040.00417.26
8.0.300.0040.00418.77
8.0.290.0030.00616.75
8.0.280.0030.00318.40
8.0.270.0030.00317.22
8.0.260.0030.00316.69
8.0.250.0040.00416.84
8.0.240.0000.00816.88
8.0.230.0000.00716.86
8.0.220.0000.00716.73
8.0.210.0000.00716.73
8.0.200.0000.00716.80
8.0.190.0070.00016.71
8.0.180.0030.00316.75
8.0.170.0050.00516.84
8.0.160.0000.00816.76
8.0.150.0060.00316.71
8.0.140.0040.00416.79
8.0.130.0050.00013.21
8.0.120.0040.00416.77
8.0.110.0070.00016.63
8.0.100.0080.00016.64
8.0.90.0070.00016.88
8.0.80.0090.00616.74
8.0.70.0000.00716.70
8.0.60.0030.00416.79
8.0.50.0030.00416.68
8.0.30.0060.01217.01
8.0.20.0150.00317.40
8.0.10.0000.00716.89
8.0.00.0120.00816.47
7.4.330.0030.00313.43
7.4.320.0060.00016.38
7.4.300.0030.00316.51
7.4.290.0030.00316.55
7.4.280.0060.00316.38
7.4.270.0000.00716.32
7.4.260.0030.00513.19
7.4.250.0040.00416.30
7.4.240.0040.00416.47
7.4.230.0000.00716.55
7.4.220.0150.00616.50
7.4.210.0070.00716.39
7.4.200.0030.00516.59
7.4.190.0030.00316.32
7.4.160.0100.01016.45
7.4.150.0140.00317.40
7.4.140.0090.00917.21
7.4.130.0080.01016.29
7.4.120.0100.00716.47
7.4.110.0110.00516.53
7.4.100.0140.00316.21
7.4.90.0000.01716.30
7.4.80.0120.00619.03
7.4.70.0100.00616.34
7.4.60.0090.00616.38
7.4.50.0020.00216.18
7.4.40.0070.00722.27
7.4.30.0100.00516.54
7.4.00.0070.00714.98
7.3.330.0030.00313.06
7.3.320.0050.00313.11
7.3.310.0030.00316.23
7.3.300.0000.00616.11
7.3.290.0140.00016.09
7.3.280.0030.01316.12
7.3.270.0110.00517.40
7.3.260.0060.01318.24
7.3.250.0160.00616.30
7.3.240.0100.00716.18
7.3.230.0090.00616.39
7.3.210.0100.00716.05
7.3.200.0120.00619.39
7.3.190.0090.01316.24
7.3.180.0060.01616.19
7.3.170.0060.01216.42
7.3.160.0090.00616.41
7.3.120.0030.01214.72
7.2.330.0140.00516.50
7.2.320.0170.00016.56
7.2.310.0130.00916.57
7.2.300.0070.01316.51
7.2.290.0110.00516.63
7.2.80.0060.00616.47
7.2.60.0080.00816.86
7.2.00.0030.01019.04
7.1.200.0000.01015.53
7.1.100.0040.00717.93
7.1.70.0040.01116.84
7.1.60.0070.01719.40
7.1.50.0090.01216.54
7.1.00.0070.07322.43
7.0.200.0030.00316.64
7.0.140.0000.07722.08
7.0.60.0070.07020.02
7.0.50.0100.08017.80
7.0.40.0000.06720.09
7.0.30.0230.04020.00
7.0.20.0200.04320.00
7.0.10.0200.08720.09
7.0.00.0270.07020.11
5.6.280.0030.07321.09
5.6.210.0070.06020.46
5.6.200.0170.07018.08
5.6.190.0070.07020.68
5.6.180.0270.07320.48
5.6.170.0230.04720.54
5.6.160.0130.06020.46
5.6.150.0030.07718.21
5.6.140.0170.07018.11
5.6.130.0070.03718.21
5.6.120.0030.04320.99
5.6.110.0000.06720.97
5.6.100.0100.08720.99
5.6.90.0030.04321.18
5.6.80.0070.08020.36
5.6.70.3170.03320.46
5.5.350.4300.04020.43
5.5.340.0070.04018.02
5.5.330.0070.08720.40
5.5.320.0370.07020.17
5.5.310.0230.07720.34
5.5.300.0130.07717.98
5.5.290.0000.05018.00
5.5.280.0070.07720.89
5.5.270.0070.07320.95
5.5.260.0130.08320.64
5.5.250.0030.08020.67
5.5.240.0030.08720.18
5.4.450.3700.03719.13
5.4.440.3130.04319.24
5.4.430.3470.04019.46
5.4.420.3200.03719.52
5.4.410.3800.04319.11
5.4.400.3770.03319.09
5.4.390.4130.04719.15
5.4.380.3430.03719.08
5.4.370.3470.03718.79
5.4.360.4170.03719.09
5.4.350.3770.03718.91
5.4.340.3230.04318.93
5.4.320.3930.04318.81
5.4.310.3370.04318.80
5.4.300.3500.03719.13
5.4.290.3370.04019.09
5.4.280.1130.04319.04
5.4.270.0100.06719.05
5.4.260.4200.03718.93
5.4.250.4270.02718.92
5.4.240.3900.04318.78
5.4.230.3470.03719.06
5.4.220.3470.03018.80
5.4.210.3530.03718.93
5.4.200.3600.04018.80
5.4.190.4230.03319.22
5.4.180.4000.03319.11
5.4.170.0070.04719.14
5.4.160.3300.03719.21
5.4.150.3370.04018.95
5.4.140.3330.03016.33
5.4.130.4000.03716.54
5.4.120.3670.05016.32
5.4.110.2900.04016.38
5.4.100.3230.03316.38
5.4.90.3270.03016.22
5.4.80.3630.04316.21
5.4.70.3470.03316.29
5.4.60.3430.04016.18
5.4.50.3200.03316.19
5.4.40.3670.03716.40
5.4.30.3300.03316.38
5.4.20.4830.02716.17
5.4.10.4170.04316.40
5.4.00.3400.03315.63
5.3.290.4170.03314.50
5.3.280.3430.04014.42
5.3.270.0100.03714.56
5.3.260.3570.04014.45
5.3.250.3530.04014.45
5.3.240.3200.04314.43
5.3.230.4170.03014.44
5.3.220.2830.03314.44
5.3.210.3230.04014.66
5.3.200.3330.03014.59
5.3.190.2300.03714.65
5.3.180.3570.04714.49
5.3.170.3100.04014.36
5.3.160.3500.04014.42
5.3.150.3500.03314.65
5.3.140.3430.04014.50
5.3.130.3170.03314.48
5.3.120.3970.03714.39
5.3.110.4200.03314.44
5.3.100.3530.03014.13
5.3.90.3470.03314.11
5.3.80.2830.03713.86
5.3.70.3130.04014.10
5.3.60.3630.03014.04
5.3.50.3470.04013.91
5.3.40.3570.02713.78
5.3.30.3300.04314.00
5.3.20.3500.03313.48
5.3.10.3300.03313.74
5.3.00.3470.03013.47

preferences:
40.4 ms | 401 KiB | 5 Q