Skip to main content

100 000 rows reached (very soon) ! :(

A

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

4 replies

B
Forum|alt.badge.img+19
  • Bill_French
  • Inspiring
  • 3264 replies
  • February 22, 2021

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.
A
  • Alex_Guillaume
  • Author
  • New Participant
  • 4 replies
  • February 23, 2021
Bill_French wrote:

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 !

B
Forum|alt.badge.img+19
  • Bill_French
  • Inspiring
  • 3264 replies
  • February 23, 2021
Bill_French wrote:

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 -

A
  • Alex_Guillaume
  • Author
  • New Participant
  • 4 replies
  • February 23, 2021

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

Reply


Most helpful members this week

Terms & Conditions