Skip to main content

Best practices for large database and searching across it


Ruchika_Abbi1
Forum|alt.badge.img+15

I’m building a solution for a client that may have around 80 K records… was thinking of breaking it up into multiple bases given that there’s a 50K record limit.
However, they need to be able to search across the bases at the same time.
I was thinking I could achieve this through a custom app that would allow them to do this search and return results from multiple bases.
Has anyone tried this? Any suggestions on how best to do this?

Regards,
Ruchika

2 replies

Databaser
Forum|alt.badge.img+19
  • Inspiring
  • 866 replies
  • July 12, 2021

Maybe off topic, and it’s price x2, but the Enterprise plan goes to 100k I believe.


Lucas_Ravassall
Forum|alt.badge.img+6

You can definitly search in multiple bases with a search API

https://community.airtable.com/t5/development-apis/search-multiple-bases/td-p/187372


Reply