On Fri, Jan 20, 2012 at 3:40 PM, John Elrick <john.elr...@fenestra.com>wrote:
> 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. > We'd like to understand what SQLite is doing differently to cause your problem, too. As you have already observed, most applications don't have this issue. I'm not sure what your application is doing to make SQLite go crazy will mallocs, but we'd like to know so that we can avoid such situations in the future. Can you try this: Can you use the sqlite3_trace() interface to create a log of all SQL statements that are evaluated. Then send me (perhaps privately) the starting database and your log, so that I can run SQLite through exactly the same set of operations you are running it through? > > > 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 > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
