Revisit Room for possible index creation.

[hussainmohd-a]

Indexes aren't free though, and there are more than one type, each suited to different kinds of query patterns and space complexity: https://archive.is/j1nTl

#282 (comment)_

[ignoramous]

See also:

AppSearch: https://developer.android.com/guide/topics/search/appsearch (Android 12+).

Squeezing performance from SQLite with Room: https://archive.is/mN83U

Deep dive into Room persistence library: https://archive.is/XaOEy

[ignoramous]

Indices aren't really required (since primary keys are approp set) except for indices required for ipAddress and dnsQuery Stats screen: 019eacb

As for app-search, that's a different issue and tracked #743

[ignoramous]

cov index for order by queries also resulted in slow performance for tables (network logs / dns logs) with > 100K entries: https://stackoverflow.com/a/50776662

a potential soln is to use primary key (auto-incrementing ID) for sorting (order by) or add an index on the sorted (usually, timeStamp) field.