I am working on a word game for Android (with minSdkLevel=9
meaning SQLite version 3.6.22) -
and would like to deliver the dictionary as a prefilled SQLite table within the app (with the help of SQLiteAssetHelper).
In the SQLite database there will be just 1 table:
create table dict ( /* contains 700 000 unique words */
word text not null
);
My question:
How to declare the table for the best performance and which kind of query to use? - to check if a word entered by player is present in the dict
table or not.
Should I create index
(is it possible to have index for text
columns at all?) or/and should I declare the word column as primary key
?
Aucun commentaire:
Enregistrer un commentaire