Better string index with Code First

Asked Feb 23 '14 at 16:40

Active Feb 23 '14 at 16:40

Viewed 122 times

I'm creating a new project and using codefirst with sql server. In this project anyone can search something in our Database looking by string search. I need to perform it. Why should I use do get the user experience better? Thia Database will grow up forever!

Is using CHECKSUM a good way?

asked Feb 23 '14 at 16:40

landrady

Is the `string` primary key ? – Ofiris Feb 23 '14 at 16:44
it can be! But Create a string index in Sql Server I think is not a good idea, is it? – landrady Feb 23 '14 at 16:47
Depends on how is it accessed, and the length of the strings, see: http://stackoverflow.com/questions/8001905/sql-server-worth-indexing-large-string-keys – Ofiris Feb 23 '14 at 16:50
https://lucenenet.apache.org/ – L.B Feb 23 '14 at 16:57

Better string index with Code First

0 Answers0