On 17 Nov 2014, at 12:48pm, RP McMurphy <rpm0...@yahoo.com> wrote: > Upon further analysis it appears that the data "shape" is different in > different periods within the table. That is, some sections have the inverse > shape to other sections. So it looked like query times would change over time > but actually they are changing because different portions of the table are > being accessed.
It would be difficult to spot that. Nice analysis. > Is it possible to tell sqlite to analyze different sections and keep separate > a record for each? No, but the amount by which such a wrong choice should increase your execution time should be extremely slow. Are you actually getting annoyingly long execution times or are you just trying to wring every last millisecond out of your application ? If the latter, then I feel you should stop worrying about this and move onto something else. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users