I have a table that captures about 100,000 records per day. As you can imagine, the size and performance of such a table would degrade as it quickly went well over 50 million records. I want to try something different, and that is the creation of a new table every day, so that the number of records in each table is more manageable. Do you think this is a good idea, or should I keep all the data together?
September 24, 2013 8:00 PM
September 24, 2013 8:03 PM