Online PHP editor | perf for udeB5

@ 2018-11-13T22:38:33Z

<?php

$sql = "
 
SELECT e.*
  FROM ( SELECT personaId
              , MIN(alternateEventDurationInMilliseconds) AS latest
           FROM EVENT_DATA
          GROUP BY personaId
       )  f
  JOIN EVENT_DATA  e    
    ON e.personaId = f.personaId
  JOIN PERSONA p
    ON p.ID = e.personaId
  LEFT JOIN CUSTOMCAR cc
    ON cc.ownedCarId = e.carId
;
 
SELECT p.ID
     , e.personaId
     , MIN(e.carId) AS carId
     , MIN(e.alternateEventDurationInMilliseconds) AS alternateEventDurationInMilliseconds
     , p.name AS p_name
     , MIN(cc.name) AS c_name
     , MIN(cc.ownedCarId) AS c_ownedCarId
     , MIN(cc.carClassHash) AS c_hash
     , MIN(ccs.full_name) AS cs_name
     , MIN(e.EVENTID)
  FROM ( SELECT personaId
              , MIN(alternateEventDurationInMilliseconds) AS latest
           FROM EVENT_DATA
          GROUP BY personaId
       ) AS f
  JOIN EVENT_DATA  e    
    ON e.personaId = f.personaId
  JOIN PERSONA p
    ON p.ID = e.personaId
  JOIN CUSTOMCAR cc
    ON cc.ownedCarId = e.carId
  JOIN CAR_CLASSES ccs
    ON ccs.store_name = cc.name
  JOIN USER u
    ON u.ID = p.USERID  
 WHERE e.EVENTID = 28
   AND e.alternateEventDurationInMilliseconds > 0
 GROUP BY personaId
 ORDER BY alternateEventDurationInMilliseconds ASC
 ";
 
";

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)
7.2.12	0.019	0.016	14.46
7.2.11	0.018	0.012	14.64
7.2.10	0.031	0.006	13.98
7.2.9	0.019	0.013	14.41
7.2.8	0.022	0.007	14.38
7.2.7	0.027	0.010	14.75
7.2.6	0.027	0.012	13.99
7.2.5	0.027	0.009	14.71
7.2.4	0.035	0.010	14.45
7.2.3	0.025	0.011	14.85
7.2.2	0.026	0.010	14.63
7.2.1	0.027	0.003	14.73
7.2.0	0.113	0.003	14.23
7.1.24	0.018	0.007	13.71
7.1.23	0.121	0.000	13.36
7.1.22	0.019	0.013	13.55
7.1.21	0.019	0.006	13.75
7.1.20	0.017	0.009	13.51
7.1.19	0.029	0.003	13.15
7.1.18	0.035	0.009	13.36
7.1.17	0.022	0.007	13.43
7.1.16	0.027	0.010	13.38
7.1.15	0.029	0.007	13.38
7.1.14	0.021	0.011	13.59
7.1.13	0.017	0.007	13.36
7.1.12	0.025	0.006	13.30
7.1.11	0.013	0.010	13.32
7.1.10	0.013	0.010	13.27
7.1.9	0.016	0.006	13.36
7.1.8	0.018	0.006	13.51
7.1.7	0.021	0.003	13.42
7.1.6	0.018	0.007	13.61
7.1.5	0.024	0.000	13.54
7.1.4	0.015	0.009	13.54
7.1.3	0.024	0.003	13.64
7.1.2	0.021	0.008	13.23
7.1.1	0.023	0.000	13.40
7.1.0	0.020	0.007	13.80
5.6.38	0.008	0.008	13.96

preferences:dark modelive preview