#community-help

Discussing Synonym Management and Performance

TLDR Narayan inquires about synonym management and performance implications. Kishore Nallan assures them of no performance drops but also declines the idea of a batch insert option, prompting Narayan to create a GitHub issue.

Powered by Struct AI

2

7
1mo
Solved
Join the chat
Oct 24, 2023 (1 month ago)
Narayan
Photo of md5-6441fd8d08a3a44e184f7cba8ddb1d72
Narayan
11:17 PM
Should be worried if I add 100s/1000s/millions of synonyms? Are there any query runtime performance drops I should be worried about? Has anyone run any such benchmarks?
Oct 25, 2023 (1 month ago)
Kishore Nallan
Photo of md5-4e872368b2b2668460205b409e95c2ea
Kishore Nallan
02:53 AM
Synonyms have their own inverted index so it should be fine. But if a given keyword matches too many synonyms then we have to do all those additional searches and merge the results.

1

Narayan
Photo of md5-6441fd8d08a3a44e184f7cba8ddb1d72
Narayan
04:33 AM
Tiny follow up - is there a batch insert option available for synonyms?
Kishore Nallan
Photo of md5-4e872368b2b2668460205b409e95c2ea
Kishore Nallan
04:34 AM
No we don't
Narayan
Photo of md5-6441fd8d08a3a44e184f7cba8ddb1d72
Narayan
04:35 AM
Do you think it would be worth supporting or is there any reason to not have it? I can create a github issue if one does not exist already.
Kishore Nallan
Photo of md5-4e872368b2b2668460205b409e95c2ea
Kishore Nallan
05:12 AM
Yes please create a GitHub issue. We can prioritise based on demand. Right now we don't have any plans to add it since most people don't have that many syns to manage.

1

Oct 26, 2023 (1 month ago)