Post reply

Fastest way to look for a word from a string matching a list of words in a lookup table

  • November 14, 2017 at 8:03 am

    #1967966

    Not sure this is ever going to go very fast.   Also, using the function that way, while it is an inline table-valued function, the problem is that it's used in a way that I'm not sure is really going to work very well.   You also are performing a REPLACE function on long string data, so that's not helping either.   You might be able to use FULL TEXT INDEXING, because your search is a CONTAINS kind of search, and it would have to be on the smaller table.  I don't know enough about FTI to help much, so Google will be your best friend in that regard.

    Steve (aka sgmunson) 🙂 🙂 🙂
    Rent Servers for Income (picks and shovels strategy)

  • November 14, 2017 at 8:18 am

    #1967974

    maybe a set up script that creates the tables and inserts some simple sample data and also the expected results would help......you have had many views and only one reply.
    just saying.

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

Viewing 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply