Problem with handling huge data collection
I have a live MySQL database table that INSERTs more than 200,000 records per day.
And I have to ganarate monthly reports from this table.
Problem is its take too much time to generate reports from huge data collection.
So, I want to move or backup the data each 3 month.
Then I can quickly run queries on the live database. How can i do this?
Subject
Written By
Posted
Problem with handling huge data collection
January 29, 2011 12:02AM
February 06, 2011 11:12PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.