Discussions

 View Only
  • 1.  Table Data Usage of a Field

    Posted 01-05-2022 14:35
    Is there a way to determine how much overall data is used in a field in a table.  I have some formula RTF fields that may be consuming a great deal of memory in one of my tables.  I am considering moving those fields to their own table and replacing them with a summary field.  Or would the Summary Field take the use the same amount of data?

    ------------------------------
    Paul Peterson
    ------------------------------


  • 2.  RE: Table Data Usage of a Field

    Posted 01-05-2022 14:53
    Only data entry fields count toward Table Size Limits.  Summary fields,  Formulas fields and lookup fields don't count against table space or application space limits.

    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------



  • 3.  RE: Table Data Usage of a Field

    Posted 01-05-2022 15:10
    Am I understanding you correctly, formula fields, including Formula - Rich Text fields don't count toward table size limits?

    ------------------------------
    Paul Peterson
    ------------------------------



  • 4.  RE: Table Data Usage of a Field

    Posted 01-05-2022 15:15
    Correct. Only data entry fields count.

    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------



  • 5.  RE: Table Data Usage of a Field

    Posted 01-05-2022 15:26
    Thank you.  That helps immensely!

    ------------------------------
    Paul Peterson
    ------------------------------



  • 6.  RE: Table Data Usage of a Field

    Posted 01-05-2022 15:31
    Also, returning to the original question, is there a way to determine how much data a field or collection of fields is using.  We have talked before about one of the tables I inherited in some of my apps that has an insane number of fields.  I need to normalize that table and want to start with the biggest return on the time invested.

    ------------------------------
    Paul Peterson
    ------------------------------



  • 7.  RE: Table Data Usage of a Field

    Posted 01-05-2022 15:34
    If you click on the field usage tab there is a link there to show how much space that one field takes up.

    But I don't think that's available in a report, so you would need to guess at the likely suspects and then click that link to see how much space is used by that field, on a one by one basis.

    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------



  • 8.  RE: Table Data Usage of a Field

    Posted 01-05-2022 16:14
    Thanks for the tip!  That will confirm how much I can gain(lose) by moving some data fields into a new table and pulling the data back in with a relationship.

    ------------------------------
    Paul Peterson
    ------------------------------