I know this is probably a difficult question and is case by case, but with the addition of sync I am debating on what to do.
I am trying to decide if I should rebuild my base into separate bases from scratch or try to clean up/restructure my current base? Or maybe even just wait a bit to see how the new sync evolves?
My current base has many tables that link together (Jobs, Contacts “employee & customer”, Customers, Cities with various tax rates, Holidays, etc.). I have probably 20 different tables in the base.
When I built my current base, I was learning a lot as I was building it and now feel I can build a more efficient base if I were to start from scratch. My current base has one table (jobs) with close to 25k records and over 300 fields, which won’t open on iOS app and causes it to crash (spoke with Airtable and nothing can really be done to make work as is due to size). This jobs table will certainly evolve over the 50,000 limit and I will have to start splitting the table up by year & eventually quarter. This is a real bummer as It would be so convenient having all my job in one base for reporting, searching, duplicating old jobs, etc. This I where I feel I will be better off with sync and having separate bases instead of separate tables.
Sometime I feel Airtable can be “too good” as I come up with an idea and simply create a solution, but then I end up with 300+ fields in a table
Just want to get some options from people that are dealing or have dealt with these issues