code_junkie

What is a suitable replacement for the SQL Like operator to increase performance?

Nov 13th, 2011
91
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.36 KB | None | 0 0
  1. List<Item> specificItems =
  2. AllItems.FindAll(i => i.Description.IndexOf(searchString, StringComparison.OrdinalIgnoreCase) >= 0);
  3.  
  4. Words
  5. -----
  6. chars | word_id
  7.  
  8. WordsToEntry
  9. ------------
  10. word_id | entry_id
  11.  
  12. CREATE TABLE WordItemOccurance
  13. (
  14. [Word] varchar(50) not null,
  15.  
  16. ItemId int not null
  17. constraint FK_Items references ItemTable(ID)
  18. )
Add Comment
Please, Sign In to add comment