Hacker News
new
|
past
|
comments
|
ask
|
show
|
jobs
|
submit
login
sams99
on Oct 28, 2011
|
parent
|
context
|
favorite
| on:
On Stack Overflow's recent battles with the .NET G...
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.
sams99
on Oct 28, 2011
[–]
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.
Consider applying for YC's Summer 2026 batch! Applications are open till May 4
Guidelines
|
FAQ
|
Lists
|
API
|
Security
|
Legal
|
Apply to YC
|
Contact
Search:
Tags are stored both in a posttags table and free text. Fts is faster for many queries.