On 05/01/11 21:32, Richard Hipp wrote: > On Wed, Jan 5, 2011 at 4:00 PM, Peter<[email protected]> wrote: > >> Sorry, I assumed everything you needed to know was in the database that I >> gave a link to: http://somborneshetlands.co.uk/things/sss-mini.zip >> I'll sort out a text schema tomorrow. >> >> > No, I'm the one that should be sorry. I didn't see the link. The database > is all we need. > > > > Richard,
I've just remembered the bug I reported in October resembles this one somewhat - http://www.sqlite.org/src/info/d30f7b2def. Explain seems to indicate it's scanning the prp_genetics and inspection tables instead of using the date index when processing the view. Did that fix make it into 3.7.4? Pete -- Peter Hardman 'For every complex problem there is a solution that is simple, straightforward - and wrong' _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
