In my experience, the only time that I’ve taxed a drive when doing a database query is either when dumping it, or with SQLite’s vacuum, which copies the whole thing.

For a pretty simple search like OP seems to be doing, the indices should have taken care of basically all the heavy lifting.