SQL query: SELECT DATE(datim) AS dt, MIN(total_time) AS min_time,
AVG(total_time) av_time, MAX(total_time)AS max_time, min(speed_download) AS min_speed,
avg(speed_download) AS avg_speed, max(speed_download) AS max_speed
FROM `forums_log`
WHERE `url` LIKE "%board.hondacrx.co.uk%"
GROUP BY dt
ORDER BY dt DESC
LIMIT 400;
Rows: 3
Note to Dave:
I have changed the code that makes these stats - if it does not get a session ID,
it will not hit any more pages (the login script on CRX-UK times out sometimes - see http_code 0). Basically,
if the first page times out, I assume the server is too busy to take another 4 hits, so don't tie it up.
Also, timeout is now @ 30 seconds.
| dt | min_time | av_time | max_time | min_speed | avg_speed | max_speed |
|---|---|---|---|---|---|---|
| 2008-08-22 | 0.195517 | 0.42798480764031 | 4.20382 | 126 | 217763.3333 | 301536 |
| 2008-08-21 | 0.18748 | 0.61956683292778 | 17.3476 | 36 | 214766.5486 | 304458 |
| 2008-08-20 | 0.187168 | 0.81465696424453 | 18.3603 | 31 | 200065.8090 | 307366 |