normalization - MySQL Table Design - User Logon Times -
i need provide following data regarding member logins example: last hour 654 last day 15,648 last week 109,536 last month 460,051 last year 5,520,614 i wondering best possible structure of table hold information in mysql db. currently i'm thinking of storing: user datetime i expect large on time , become slow query. is there better way structure table information on logins - hourly, day, week, month, year etc? $current_time = strtotime(date('d-m-y g:i:s a')); $last_hour = $current_time - 3600; $last_day = $current_time - (3600*24); $last_week = strtotime("-1 week"); $last_month = strtotime("-1 month"); $last_year = strtotime("-1 year"); // count // count last hour $sql = "select count(user_id) cnt `your_table` datetime>='$last_hour' "; // count last day $sql = "select count(user_id) cnt `your_table` datetime>='$last_day' "; // count last week $sql = "select count(user_...