I have a SQLite database and a table, which can grow up to 100.000+ rows. I need to query data in the table really (!) fast. There are two ways to query the data.
- I have an index of type
string, consisting of always 15
- There are two columns, x and y of type
I am thinking about creating an index on the
string column OR creating an index on the
ycolumn. However, the problem is: There will be situations where I am inserting new records into the table every second and the whole thing is running an a phone, not a server.
I am concerned about
INSERT performance vs. search performance... Can anyone give an educated guess on this?