On Thu, Nov 19, 2015 at 12:39:41AM +0000, Simon Slavin wrote: > On 19 Nov 2015, at 12:26am, Nico Williams <nico at cryptonector.com> wrote: > > two concurrent scans of the same table should be able to go faster > > than the same two scans in series. > > SQLite is not processor-bound, it's file-bound. Both > threads/processes need to continually read blocks from disk and a disk > can only answer one request at a time.
Two table scans of the same data in sequence are going to cost more than two table scans of the same data concurrently. Nico --
