Skip to main content

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.


Alex

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.


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 !


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.



This post provides some additional details concerning #1 -







Love it.

We will find a solution for sure thanks to you. 🙂


Reply