Skip to main content
Question

What is the record limit for a single table?

  • March 29, 2018
  • 0 replies
  • 87 views

What is the record limit for a single table?
This topic has been closed for replies.

  • Registered
  • March 29, 2018
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.

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.

  • Author
  • Registered
  • March 30, 2018

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.


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.

  • Author
  • Registered
  • March 30, 2018
Thank you

  • Registered
  • March 30, 2018
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.