Tag List in stackoverflow

Question

I am working on a site in asp.net mvc. There is a form in which the user is prompted to put some information along with tags similar to stackoverflow. this tag information is stored in one table in the Tags field.

Now I want to show them help for selecting tags from a list (same as stackoverflow). how can i extract it from the table. It won’t be too much to run a query again and again for each letter they type, because I will extract unique tags from my table. Or I need to have another tagslookup table where I have to save unique tags.

Help will be appreciated.

Hi

Parminder

Answer 1

When we needed to do something similar, we saved the “tags” (words) in memory and created a search tree .

Do not run too many queries over and over for each letter they type, because I will extract unique tags from my table.

It really depends on the specific case. Personally, I would not go to db every day, but this may be good for your scenario.