Discussions

Expand all | Collapse all

What is the record limit for a single table?

  • 1.  What is the record limit for a single table?

    Posted 03-29-2018 16:08


  • 2.  RE: What is the record limit for a single table?

    Posted 03-29-2018 19:36
    I've seen over 10M, but it really depends on the amount of fields and data types you are capturing with each of those records.  
    More fields = more data (even if those fields are empty). 

    It more of a size thing, and really it just affect performance and cost the bigger they get.


  • 3.  RE: What is the record limit for a single table?

    Posted 03-29-2018 19:37

    Thank you



  • 4.  RE: What is the record limit for a single table?

    Posted 03-29-2018 20:07
    If you tell us about how many records and how many fields we can comment if you are still in the sweet spot for Quick Base.


  • 5.  RE: What is the record limit for a single table?

    Posted 03-29-2018 21:23

    Fields = 77

    Records 619,759

    Table shows size as 269 MB

    I actually figured why records wouldn't load but due the size the table is getting, I would still like to know when I might need to split records or fields off into another table.  Thank you.



  • 6.  RE: What is the record limit for a single table?

    Posted 03-29-2018 22:27
    So y�u are at about 50% full. The limit is 500 MB per table. App settings, app management, show statistics tells you the % by table.

    There is no limit to the number of records, it�s a space limit or the start of performance issues that is your limit.


  • 7.  RE: What is the record limit for a single table?

    Posted 03-29-2018 23:49
    Thank you


  • 8.  RE: What is the record limit for a single table?

    Posted 03-30-2018 09:10
    Fields = 77

    Records 619,759

    The table shows size as 269 MB

    I actually figured why records wouldn't load but due to the size the table is getting, I would still like to know when I might need to split records or fields off into another table.