100 000 rows reached (very soon) ! :(

[Alex_Guillaume]

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

[Bill_French]

Hi @Alex_Guillaume, and welcome to the community!

Alex_Guillaume:

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

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.

[Alex_Guillaume]

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

[Bill_French]

Bill.French:

Identify transaction records that can live inside records as JSON objects.

This post provides some additional details concerning #1 -

1 million+ Excel/CSV files Importing / Exporting

Hi Jovo, and welcome to the community! I appreciate fast terse answers; no BS’ing around, quick, to the point, move the ball downfield! @ScottWorld is really the right guy to have inside the two-minute warning. However, there are cases were it may be worthwhile to know more about the nature of the data before dismissing Airtable based on a record count alone. Sometimes, a time-out should be called to strategize the next play. Lil’ story… I have a client with about 20,000 Airtable client reco…

[Alex_Guillaume]

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