SQL fx
I had to notice that having a lot of tags in my Questions and Answers causing a delay in reading that page.Blog tags mechanism had different approach, but tags for Questions and Answers are kind of wider and open for more in future.
That is when I spent few days learning new SQL techniques to speed it up, so I ended up creating SQL function (I actually found it online) to do word splitting which splits string with spaces into rows of a table, then create SQL to create and update a table made specially for these tags, this table will have to be created every time new Question added.
ANmars webdesign programming blog