Your Link:
https%3A%2F%2Fstackoverflow.com%2Fquestions%2F7349189%2Foptimizing-select-with-transaction-under-sqlite-3