March 2, 2016 at 3:13 pm
I have a table that has a list of category codes and keywords.
For example code=1234, keywords=bakery,baking,pastry
I want to search against another table that has titles, looking at all the keywords and return the category code that found a match.
If my table had a title of "Famous French Pastries"
I would want to return "Famouse French pastries", 1234
My titles table has about 1M rows and grows about 20k / day.
My category table has about 25k records.
What is the best way to search between the two tables?
Full text search? Split out the keywords into a single row and join the two tables?
Any ideas are welcome, thanks...
March 3, 2016 at 6:45 am
Mike Wiz (3/2/2016)
I have a table that has a list of category codes and keywords.For example code=1234, keywords=bakery,baking,pastry
I want to search against another table that has titles, looking at all the keywords and return the category code that found a match.
If my table had a title of "Famous French Pastries"
I would want to return "Famouse French pastries", 1234
My titles table has about 1M rows and grows about 20k / day.
My category table has about 25k records.
What is the best way to search between the two tables?
Full text search? Split out the keywords into a single row and join the two tables?
Any ideas are welcome, thanks...
In my opinion, the best way is to split your keywords. Do not use a WHILE loop or CURSOR to do this. Instead, search this site for the blazing-fast delimited8kSplit function and use that.
However, that will not allow you to match 'pastry' with 'pastries'. If you need this kind of matching, things will have to get more sophisticated and you'll possibly have to look at full-text searching.
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply