Put text data in FTS table

wurzeljena / problembase

Database for mathematical problems, for Wurzel e.V.

1 stars 0 forks source link

Put text data in FTS table #5

Closed aaronpuchert closed 11 years ago

aaronpuchert commented 11 years ago

To improve the speed of full-text searches, it might help to create a Full Text Search table containing all text snippets: problems, comments and solutions. As an outline:

[x] create FTS table for "files",
[x] link concerned tables by file_ids and
[x] change related PHP - that's going to be hard.

aaronpuchert commented 11 years ago

That would automatically solve #4. (provided an intelligent implementation)

aaronpuchert commented 11 years ago

Database changes in 466df059996aba921e715483f71c45cf462f7b52, following three commits in branch fts implementing related changes in PHP.