While trying to sleep last night I got the idea that I should use fulltext indexing for all columns involved in searching in the MySQL photograph db that I'm working on, also those that just contain single words. The reason for that would be to take advantage of the flexibility of the boolean mode, which would make the creation of queries from all kinds of web input a lot easier to handle.
Are there any obvious drawbacks to this apporach, except that it might seem a little weird and that I won't be able to use the InnoDB engine?
This topic is now closed. New replies are no longer allowed.