[sqlite] First-N query time scaling with table size

On Fri, Apr 24, 2015 at 8:22 PM, Keith Medcalf wrote: > > Your query has to visit every row of table d and execute the correlated > subquery multiple times. > > You need to devise a way to do this only once for each d.m and then join that > table back into your query. > >>sqlite < demo.sql >

[sqlite] First-N query time scaling with table size

On Fri, Apr 24, 2015 at 7:56 PM, Simon Slavin wrote: > > On 25 Apr 2015, at 1:12am, John Pitney wrote: > >> The results are the following, on a Windows 7 64-bit platform: > > Please do ANALYZE, then check your times again. Inserting an ANALYZE just before the final SELECT

[sqlite] First-N query time scaling with table size

9|20|9,19,29,39,49,59...|1.0,1.0,1.0,1.0,...|199 10|20|10,20,30,40,50,6...|1.0,1.0,1.0,1.0,...|200 Run Time: real 2.090 user 2.074813 sys 0.00 -- John Pitney john at pitney.org