On 2014/11/17 14:48, RP McMurphy 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. Is it possible to tell sqlite to analyze different sections and keep separate a record for each?
Ok - this one is tricky - but I bet folks on here would love a go at cracking that. Can you post a moderate size section of the DB which includes the problem areas on a file-share somewhere (feel free to obscure the data if it is sensitive but try to keep the shape in tact - to be sure, whatever you produce should still cause the problem you described). Then post the queries that produce the bad timings (multiple to show the relevant discrepancies) and maybe some description of what it is you really want the intended result to look like (in case the queries produce somewhat different results to what you need).
Sounds like an interesting problem. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
