On the maintenance of databases, to see our heroes! My company is a Business card companies have a lot of data per day (including public transportation, rental, the MTRC), we used the system is transaction data from these 12 log table, log table each month on behalf of the data, there was a re-row table for the daily data off plots. Now the system has been operating for almost a year and more, 12 log table and a row of the heavy amount of data is very large, data processing has made it clear on several occasions was dropped, and now we want to ensure that a program for data backup the past, under the premise of the data processing speed, you do not know what suggestions heroes? [ Closed window ]