Testing relational design impact on reporting performance.
30,000 records of:
- Incrementing Id
- 20 Random Numbers
- 20 Random Strings
- 20 Random Paragraphs
- Report Field
Test is to loop through every record. Concatenate the first number, string, and paragraph. Store the value to the report field and move to the next record.
Additional tests where then performed for
- 60,000 records
- 100,000 records
