I have a news website where I store my articles in a table that looks like that:
Id title data
Where data contains the content of the article and is the biggest column in the database by far. The table currently takes 10 GB.
I have an issue that queries that search by content on this table take extremely long time as it is done by like clauses instead of full text.
My team told me that there was a full text index on the column, but it was too big and gave them hard time, even crashing the database.
What is the best way to deal with this issue?