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:
1. Searchable recipes (recipes that are official, checked, correct values).
2. non searchable recipes (copies of other recipes, non verified or user generated)
Should I have 2 different tables for these two groups or put everything into one table and have a column
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:
1. Searchable recipes (recipes that are official, checked, correct values).
2. non searchable recipes (copies of other recipes, non verified or user generated)
Should I have 2 different tables for these two groups or put everything into one table and have a column
searchableLet's say if I only have 300 searchable recipes and 5 million non searchable, would that impact performance in any way?
