Skip to main content

Best practices for large database and searching across it

  • July 6, 2021
  • 2 replies
  • 35 views

Ruchika_Abbi1
Forum|alt.badge.img+17

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+25
  • Brainy
  • 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+8

You can definitly search in multiple bases with a search API

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