I need to cut some fat out of one of my apps. There is a table that has thousands of blank fields. I just looked at the data from a little over 10,000 records. For example, I have a chunk of this table with 175 fields and there are currently 10,006 records. That gives me a total 1,751,050 fields and there are only 527 of those fields. How much if any would be cut out if the overall memory usage if these fields were deleted and the limited data was moved to another table? Another concern with the current approach (which was dictated by the business group) is the potential for redundant data. Maybe I should step back at this point and state the use case. There are 25 sets of 7 contact fields. The business group is working out of a spreadsheet and this was their approach for handle multiple contacts while using Excel.
Thank you for taking the time to read this. I look forward to your feedback.