I have am designing a database which will hold testing records. For one of the tests that I am storing, there are up to 500 results that need to be stored. For example, the log I would put into the database has values like, serialNumber, TestDate, TestTime, Operator, and Test_X. Test_X has a few parameters that need to be stored like, attrib_X, and Attrib_Y, and it has an array of 500 test results. The order of the results are not important.
Originally I created a table for the GeneralTestInfo, and another table for Test_X attributes (attrib_X, attrib_Y, etc.) and then another table for the 500 Test_X result values. But I realize that the Test_XResults table would grow to be very big way to fast.
Does anyone have any good suggestions on how to partition this data?