asaidi
asked on
full text index
Hi
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
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
ASKER
error is
1214 the used table does not support full text indexes
1214 the used table does not support full text indexes
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Using MySQL full-text index will definitely help if you are doing keyword searches. Just note that there is also a limit to it's scalability. It's good if MySQL is still able to cache the index in memory, but if not, performance may still be unsatisfactory. Suggest you also consider 3rd-party engines like Sphinx (see http://sphinxsearch.com/.) - that of course assumes you have control over your servers.