Text search emails and other json items
-
Problably SQL Server is not the best solution
What would you use for searching lots of emails / jsons on specific terms?
We're trying to provide a solution to business to allow to search if a specific mail is sent
Like subject contains X sent around interval. Body contains Y
-
SQL Server is not the right tool for this task!
The ambiguities of natural language rule out any direct string or pattern-matching approaches unless strict upstream contextual restrictions are applied, i.e., a list of predefined subjects and immutable content templates. Problems like this one have successfully been tackled using Natural Language Processing (NLP). NLP has been around for several years, simpler and less resource intensive than large language models (LLM), yet perfectly adequate for the task.
-
I'd tend to agree with Eirikur here. You can work with FTS and Contains but it's a weird programming paradigm and a bit flaky to get working. It is possible to get it working, but ElasticSearch or Lucerne is better.
-
Thanks for the replies
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply