Discussions

Expand all | Collapse all

How Much Memory Does an Empty Field Use?

  • 1.  How Much Memory Does an Empty Field Use?

    Posted 14 days ago

    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
    ------------------------------


  • 2.  RE: How Much Memory Does an Empty Field Use?

    Posted 14 days ago
    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
    ------------------------------



  • 3.  RE: How Much Memory Does an Empty Field Use?

    Posted 14 days ago
    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
    ------------------------------



  • 4.  RE: How Much Memory Does an Empty Field Use?

    Posted 14 days ago
    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
    ------------------------------