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” :slightly_smiling_face: as I come up with an idea and simply create a solution, but then I end up with 300+ fields in a table :slightly_smiling_face:
Just want to get some options from people that are dealing or have dealt with these issues :slightly_smiling_face:
That’s a question that I’m hearing from a lot of people and as you guessed, it’s not a simple straight up answer.
Yes, I would definitely start planning which could include a good house cleaning of your current base. Some careful planning would go a long way as well. Other than testing and planning, I (personally) wouldn’t recommend letting go of your current system just yet. Syncing is too new to rely on it just yet, especially at the volume of data that you’re using.
Having said that though, it definitely sounds like this new feature will be advantageous to you whenever you do decide to revamp.
Keep us informed as you move along.
This is where I’m standing at. I don’t have nearly as much data as you do, but the tables I have are so intertwined I don’t think there’s a simple way to split in multiple bases (something I need) without having to enter a lot of data again. I suppose links between tables will be lost and an infinite amount of manual work would be needed, prone to many errors.
I just wanted a button to “create a copy of this table to another base and sync to this one with mapped fields”. That would be awesome!
I recently went through this process of splitting 3 tables out of a base with about 35 tables in it.
Those 3 tables were all inter-linked with eachother, and with 1 other table which was remaining in the original base. It was not a ton of data, so probably nothing on the scale you guys ( @RnJ, @Fernando_Martinewski ) are looking at.
However, I hope to encourage you that the process was not as painful as I expected it to be.
Here’s kind of how I did it, so far as I can remember:
When I did things in this order, I did not have to change any data – as I change the field types, the data types restored themselves to how they looked in my original base, including linked records, etc. I was expecting to have to do a ton of clean up, but in reality, it went pretty smoothly. I was really impressed.
I would definitely suggest carefully inspecting everything before deleting your original tables, though. Make absolutely certain you’ve gotten your links established as needed.