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? On the maintenance of databases, to see our heroes! You are not a month? "Now the system has been operating for almost a year and more," then the previous year's record in other areas where the grindstone. You are doing the heavy emission of not understandable. In one month the sides will focus Why? On the maintenance of databases, to see our heroes! What does it mean that there can also scale up users log data? On the maintenance of databases, to see our heroes! Build a reservoir with the same official at the reservoir, guided past historical data, not on the official database can be deleted? Of course, expanded memory to spend money! [ Closed window ]