Thursday, July 12, 2012

How to do Suggestions in RavenDB

How to do Suggestions in RavenDB:

This code works, but it isn’t ideal. In fact, it contains an major problem. It uses string.Format("*{0}*", term), which is identical to doing a Foo LIKE ‘%’ + @term +’%’ in SQL. And bad for the same reason, it means that we can’t use the index efficiently, but have to scan the entire index.




DIGITAL JUICE

No comments:

Post a Comment

Thank's!