So I have question. is it ok if I put all data in one table by days (by date) in resul I will have lot of rows
day 20021025 - 45000 rows day 20021026 - 23445 rows day 20021027 - 389023 rows day 20021028 - 78632 rows total = 536100 rows of data I count web page hits and hosts by hourly rotate and date (and one month will be woosh tons of data millions of rows) all this data is in one table so is it ok? and when I need to get some statistics data then I query by date and name and ip - and so on ? or I need to seperate or move each day in some history table and active table will hold only active day of data ? for me is better to keep all data in one table of course but who knows how to do better ? if there is way to do better of course :) --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
