Adding Full-Text Index to other columns

Would there be any drawbacks to adding Full-Text Index to lc_products_info.name?  I'm writing SQL to search across multiple carts and want to use MATCH...AGAINST on the name column as well as the description column.

I don't want to do something that will mess up how LiteCart operates.

tim

You can add as many MySQL indexes as you like. It should not affect the other operations.

Ezt a témát a hosszú inaktivitás miatt bezártuk. A hozzászólás nem lehetséges.
View code on GitHub