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 15characters
- There are two columns, x and y of type
decimal(7,4)
anddecimal(6,4)
I am thinking about creating an index on the string
column OR creating an index on the x
and y
column. 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?