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)
5.4.250.0470.03319.07
5.4.240.0470.04018.94
5.4.230.0400.03718.98
5.4.220.0500.06318.86
5.4.210.0370.03719.24
5.4.200.0330.04719.24
5.4.190.0330.04318.84
5.4.180.0430.04018.86
5.4.170.0470.03318.97
5.4.160.0470.06019.17
5.4.150.0330.04019.29
5.4.140.0430.04716.54
5.4.130.0330.04716.28
5.4.120.0330.04716.28
5.4.110.0470.05716.56
5.4.100.0500.04016.54
5.4.90.0500.04716.45
5.4.80.0500.06316.54
5.4.70.0570.04016.44
5.4.60.0430.04016.43
5.4.50.0600.05316.34
5.4.40.0470.03316.51
5.4.30.0500.03016.34
5.4.20.0570.06716.53
5.4.10.0530.06016.19
5.4.00.0570.06015.75
5.3.280.0530.05314.45
5.3.270.0470.03714.51
5.3.260.0400.03314.55
5.3.250.0370.03314.70
5.3.240.0330.03714.63
5.3.230.0500.06314.45
5.3.220.0270.04714.45
5.3.210.0500.06314.41
5.3.200.0400.04314.42
5.3.190.0470.04714.42
5.3.180.0470.05314.42
5.3.170.0600.07014.42
5.3.160.0500.03314.59
5.3.150.0670.05314.41
5.3.140.0400.04314.62
5.3.130.0400.04714.60
5.3.120.0470.04014.40
5.3.110.0600.06314.38
5.3.100.0430.04313.89
5.3.90.0470.03313.93
5.3.80.0470.03313.86
5.3.70.0400.03713.95
5.3.60.0400.04014.05
5.3.50.0370.04313.78
5.3.40.0470.03313.78
5.3.30.0570.05313.81
5.3.20.0470.03013.53
5.3.10.0600.05313.46
5.3.00.0530.05313.59

preferences:
140.28 ms | 1394 KiB | 7 Q