SQLite fetch from large database?

Question

Android

Interested in the question, how fast will the selection of 1 element from the database table, where the number of records is 10 ^ 6, 10 ^ 8 ?
Table format:

CREATE TABLE `table` (
  `text`	TEXT NOT NULL,
  `foreignKeyId`	INTEGER NOT NULL,
  PRIMARY KEY(text)
)

PS It didn't work out to google the timings, but I haven't had time to check it yet.

Answer 1

SELECT * FROM `table`
WHERE `text` = 'mytext'

the request will be executed instantly. because the text field is the key, which means it's in the index.
if you need to add other fields as selection criteria, add them to the index. and everything will be fast.

Answer 2

Yes, I checked. Sampling by indexed field takes no more than 1ms.