How index can help speed up SELECT query
query = "SELECT id AS _id, entry_id, r_ele_value, k_ele_value, gloss_value
FROM search_eng WHERE r_ele_value LIKE '"+hiragana+"%' LIMIT 20";
This query is working very slow. So I have created index for r_ele_value
in SQLite Expert Professional.
How to use created index to speed up data retrieval from large table(about
20MB)?
No comments:
Post a Comment