Forum Discussion

PaulPeterson1's avatar
PaulPeterson1
Qrew Assistant Captain
5 years ago

How Much Memory Does an Empty Field Use?

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.



------------------------------
Paul Peterson
------------------------------
  • Somewhere in a place that I can put my hands on there is a knowledge base article that describes the actual amount of space I feel useless. But much easier way to do this is to go to one of your empty fields and click on the usage tab in the field properties and there is a button to show how much space it's using.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • PaulPeterson1's avatar
      PaulPeterson1
      Qrew Assistant Captain
      Thank you.  That gave me a little guidance, but didn't get to the heart of the matter.  The usage info only says less than 1 MB.  Can you point me to the right place to search?

      ------------------------------
      Paul Peterson
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        I can't locate that page now, but if you want an answer to how exactly much space a blank fields takes up, and you have a lot of data, just take note of your table size, then add a blank text field and then see how much it grew.

        ------------------------------
        Mark Shnier (YQC)
        Quick Base Solution Provider
        Your Quick Base Coach
        http://QuickBaseCoach.com
        mark.shnier@gmail.com
        ------------------------------