here is my situation:
I have way too much information in 2 of my tables (stats for an affiliate program) so when affiliates try to access the stats, it times out. What I'd like to do, is create a table that would be used for the stats of the current day and one for the current month. And I would run a php file once a day to put the previous day stats that are still on the current day table to current month table.. and I would create one table per month..
so far, is this a good idea?
What I need here.. is a way to 'transfer' the data over another table.. what's the best way to do that?!
It is kind of urgent!