Thursday, December 8, 2011

My answer to "What actually contains question_title table?"

This is my answer to a Question on Support site for LampCMS project


It stores titles of questions.
Simple as that. The interesting thing about it as that this table has a full text index of titles.
Using full test search of mysql it is then easy to find "Similar" questions for a new question.
It is also used for the search feature of the site - the "Search" form uses it.
In the future the search feature may be powered by a more sophisticated search engine, but for now it's powered by mysql full text search. It's very easy to setup and it does the job.

No comments:

Post a Comment