On 12 Jan 2010, at 1:33pm, ve3meo wrote: > Attention needs to be paid to what changed between 3.6.17 and 3.6.18 that > has adversely affected performance and why is it that ANALYZE is > deleterious. Is it just this database structure that has been affected?
The database structure has not changed. It is optimisation of a particular kind of query which seems to be working differently -- and not as well. Unfortunately, the example supplied is extremely complicated and it's not easy to tell which aspect of the query is at fault. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users