Search Advice
Hi, I have a table called profiles that has several fields Name (str), Username (str), Email (str), Rank (int), Tags (array(str)), Age (int), Gender (str), etc...
I want to be able to do full text search and typeahead while being able to filter and sort on name (a-z, z-a), username (a-z, z-a), rank (low-high, high-low), tags (filter by specific tags), age (range, high-low, low-high), gender (filter by Male, Female, Non-binary, etc...)
I have about 500k profiles and growing, I want some advice on how I would efficiently query this table with my needs.
Thanks!
2 Replies
Thanks for posting in <#1088161997662724167>.
Reminder: If you have a Convex Pro account, use the Convex Dashboard to file support tickets.
- Provide context: What are you trying to achieve, what is the end-user interaction, what are you seeing? (full error message, command output, etc.)
- Use search.convex.dev to search Docs, Stack, and Discord all at once.
- Additionally, you can post your questions in the Convex Community's <#1228095053885476985> channel to receive a response from AI.
- Avoid tagging staff unless specifically instructed.
Thank you!
Hi Zeroday, the way I approach this is
1) define what field(s) you are applying the full text search on.
2) Then, think about what equality expressions you can include into the withSearchIndex()
3) Then, add filtering for each returned item as effectively inquality expressions/
Here's an example from my personal website: https://discord.com/channels/1019350475847499849/1353141302451114074/1353804510862250065
4) Then think about pagination