Most Efficient Way To Store Keyword Searchable Data

As the title says, I need to know what some of y'all think is the best way to store large amounts of keyword searchable data.

At the moment I'm thinking of storing that data as TEXT with a FULLTEXT index, and searching it with boolean searches. Is there a faster and/or more efficient way of storing and retrieving this data?

By the way, there will be millions of records in this database.

 

It depends on the nature of the data. There's no one most efficient way for all data.

 

I prefer VARCHAR than TEXT, but there's no big performance difference.

Regarding the index, you should use a HASH type index if you're going to select by exact match keywords or a BINARY TREE type if you're going to select keywords by ranges, like keywords starting with 'a' or things like that.