Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

100 000 rows reached (very soon) ! :(

Topic Labels: Base design
679 4
Showing results for 
Search instead for 
Did you mean: 

Hi Community !

We have a database that count 80 000 records… and counting… (We are limited to 100 000)

Could someone hep me on a way to split my database ?

For example… I tried to host “cities” table in an other base and sync this one… but if I sync all the rows in my main base, that does’nt make any change ! Sync row are counted in my main database.

Any clue, anybody ?

Thanks in advance.


4 Replies 4

Hi @Alex_Guillaume, and welcome to the community!

The way I do it typically falls into three dimensions of record optimization.

  1. Identify transaction records that can live inside records as JSON objects.
  2. If #1 fails to provide relief, identify records that can live elsewhere (such as Firebase) and page into and out of the operation tables of the base.
  3. If #1 and #2 fail to provide relief, identify records that should be designated “at rest” and design a methodology/process to revive them if/when needed in Airtable.

Thanks a lot Bill for your answer. I’ll discuss that with my team. Thanks a lot !

This post provides some additional details concerning #1 -

061e86f085b7e644da83efd9d8671d5952bdd5cb.png 061e86f085b7e644da83efd9d8671d5952bdd5cb.png

Love it.
We will find a solution for sure thanks to you. :slightly_smiling_face: