You side-stepped the OP's question, predictably. NetWallah managed to make an interesting and helpful technical suggestion even without having an answer to the problem.

Could you please cite the SQLite documentation which suggests the wisdom of using transactions for SELECT statements? Barring that, please provide benchmark code supporting your position that it is a best practice. COGTFO®