I don't mean to blow anyone off, but there are over 100 prepared queries involved in a very interlaced manner. Getting the EXPLAIN data is very time consuming and since we've gone way past that point already by obtaining call stack information, I am not interested in revisiting the territory unless there is a very good reason for it. At least I know we can successfully upgrade to 3.7.5 without any performance issues. It would be nice to understand what is going on from that version forward, however, because it is important that we be able to continue upgrades in the future.
On Fri, Jan 20, 2012 at 2:55 PM, John Elrick <john.elr...@fenestra.com>wrote: > The problem is not in the queries. The problem is in a two order of > magnitude increase in _mallocs between the versions. The _mallocs are > coming from sqlite3Parser. > > > On Fri, Jan 20, 2012 at 2:37 PM, Max Vlasov <max.vla...@gmail.com> wrote: > >> On Fri, Jan 20, 2012 at 10:05 PM, John Elrick <john.elr...@fenestra.com >> >wrote: >> >> > The change which results in a slow down occurred between 3.7.5.0 and >> > 3.7.6.0. >> > >> > >> What about EXPLAIN difference? Or just outputs of this prefix from both >> versions? >> >> Max >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> > > > > -- > John Elrick > Fenestra Technologies > 540-868-1377 > > -- John Elrick Fenestra Technologies 540-868-1377 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
