i have a database table that contains 1 million record and it is growing and growing
and now it is very very slow to see the result via php
my question is it good to create full text index on my table..i m trying but it is not allowing me to create full text index..
or is there another way to speed up the result for a end user
any help please