On 18 Nov 2015, at 10:58pm, Nico Williams <nico at cryptonector.com> wrote:
> Can SQLite3 run the sub-queries of a UNION ALL with any degree of > concurrency? E.g., with its co-routines? SQLite always has the bottleneck of access to the file storage medium. Many posts to this list have complained that implementing multi-threading or multi-processing does not speed up SQLite significantly, and in some cases makes things worse. The problem here is not that SQLite does this job inefficiently, but that the job is a bit weird. If you know you're going to have to diff two versions of the same database, you have your program write a log of the modifications it makes. Simon.
