Sage 100

 View Only
  • 1.  Is there a limit to the number of records a UDT can contain?

    Posted 07-28-2021 13:42

    Or a size limit?
    TIA!



    ------------------------------
    Therese Logeais, Technology Integrators
    ------------------------------


  • 2.  RE: Is there a limit to the number of records a UDT can contain?

    Posted 07-28-2021 13:44

    I've had a UDT with 1M+ records before that didn't give me any performance issues when used in a report where it was the only table.  As for size limit, I believe the file would be split into sequenced files like the other M4T files that get large (AR_InvoiceHistoryDetail, IM_ItemTransactionHistory, etc).



    ------------------------------
    David Speck II
    Tennessee Software Solutions
    ------------------------------