Discussions

 View Only
  • 1.  Limits on Dataset?

    Posted 05-21-2020 14:40
    What is the maximum app size/record count in Quick Base?

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


  • 2.  RE: Limits on Dataset?

    Posted 05-21-2020 15:06
    There is no limit on the record count. However the maximum size is 500 MB. 

    The only fields that take up any space are data entry fields. Summary and look up fields and formula fields do not take up any space.

    While there is help text I could probably locate if I put my mind to it truthfully the easiest way to estimate how many records your table will hold is to put in a representative quality of records and check what the record count is and then look in App Management, and Show Statistics to see how full the table is.  The table is 10% full then you can add 90% more records.

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



  • 3.  RE: Limits on Dataset?

    Posted 05-21-2020 15:21
    Thank you for the info.  It is entirely possible the app will have more the 250,000 records.  The largest table currently has 120,000 records and a file size around 60 MB.

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



  • 4.  RE: Limits on Dataset?

    Posted 05-21-2020 15:27
    So you will be able to get to an even 1 million records.  500/60 * 120,000

    99% of the time there is no practical limit on the app size, just individual table limits.  The exception,  I understand, is if you get into thousands of simultaneous users.


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



  • 5.  RE: Limits on Dataset?

    Posted 05-21-2020 15:52
    I don't expect to see thousands of simultaneous user, but definitely hundreds

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