来自阅读 这个问题，听起来您可以从使用 APSW sqlite 模块.不知何故，您可能是您的 sqlite 模块的受害者，导致您的查询以某种性能较低的方式执行.

From reading this question, it sounds like you could benefit from using the APSW sqlite module. Somehow you may be victim of your sqlite module causing your query to be executed in some less performant manner.

我很好奇所以我自己尝试使用 apsw.这并不太复杂.为什么不试试看呢?

I was curious so I tried using apsw myself. It wasn't too complicated. Why don't you give it a try?

要安装它，我必须:

1. 提取最新版本.

2. 让安装包获取最新的 sqlite 合并.

1. Extract the latest version.

2. Have the installation package fetch the latest sqlite amalgamation.

python setup.py fetch --sqlite

sudo python setup.py install

import apsw
<...>
conn = apsw.Connection('foo.db')