I want to use a table with a column that should have a million records and it has to retrieve the results very fast.
Im going to use it in a query like below
Database : MySQL
select tags from tags_master where tags like 'A%';
Im trying to use it in typeahead. i tried with sample data, but for a million entries it is taking so much time.
I already tried appying indexes on that field. is there any other trick to optimize it further for typeahead purposes ?
Thanks in advance.