News for hackers. Stuff that matters.
Re:On Stack Overflow's recent battles with the .NET Garbage ... by mattmanser on Friday October 28, 2011 @05:29AM (#3167583)
Less a stop watch in the brain, more likely a case of simply pressing F12 in the browser. All of the consoles have profilers these days.

I must admit I am a little surprised that tags are stored as a free text field.

Re:On Stack Overflow's recent battles with the .NET Garbage ... by sams99 on Friday October 28, 2011 @06:00AM (#3167648)
The issue popped up once in a hundred times, in general people do not notice.

Tags are stored both in a posttags table and free text. Fts is faster for many queries.

Re:On Stack Overflow's recent battles with the .NET Garbage ... by sams99 on Friday October 28, 2011 @07:35AM (#3167847)
I do admit it surprised me that we stored tags in an fts field when I started, but after a few months it made quite a bit of sense, the queries are just way faster.