Table size and full text search performance
Hello, I am using supabase and want to implement full text search.
I want to store 2 different types of recipes:
Let's say if I only have 300 searchable recipes and 5 million non searchable, would that impact performance in any way?
I want to store 2 different types of recipes:
- Searchable recipes (recipes that are official, checked, correct values).
- non searchable recipes (copies of other recipes, non verified or user generated)
searchable?Let's say if I only have 300 searchable recipes and 5 million non searchable, would that impact performance in any way?