CODEWITHSUNDEEP
c#sql-serverasp.net-mvclucene.net
Marco
Marco

Reputation: 2473

asp.net mvc - searching

I have a requirement where a user can type in a keyword and the search should look at 4 columns to match against (name, city, state, zip) and return the search results. I'm wondering if I should use a LIKE clause, Free Text Search, Lucene .net, etc. also, I am using sql server.

Pros/Cons?

Any suggestions would be greatly appreciated.

Upvotes: 1

Views: 167

Answers (1)

Retired_User
Retired_User

Reputation: 1595

Like clause would be slow for lots of rows, but should be ok for 1k rows/year (then, in 10 years you'll probably want to optimize it).

Upvotes: 1

Related Questions