What else could trigger a call to sqlite3ResetInternalSchema()? I'm getting a clear breakpoint tracing back to such innocuous calls as _sqlite3_step.
On Wed, Jan 18, 2012 at 3:31 PM, Richard Hipp <d...@sqlite.org> wrote: > On Wed, Jan 18, 2012 at 3:12 PM, John Elrick <john.elr...@fenestra.com > >wrote: > > > > > Total times _malloc called in test: 69,859,114 > > > > Times calling _malloc: 57,679,282 > > sqlite3Parser(10) > > sqlite3RunParser(9) > > sqlite3Prepare(8) > > sqlite3_prepare(7) > > sqlite3_exec_inner_loop_invoke_callback(6) > > sqlite3_exec_outer_while(5) > > sqlite3_exec(4) > > sqlite3Parser(3) > > sqlite3RunParser(2) > > sqlite3Prepare(1) > > sqlite3_step(0 > > > > It looks like you might be doing something that is forcing SQLite to > constantly reparse the schema. > > * CREATE or DROP statements > * Registering new collating sequences > * Registering new application-defined functions > * ATTACH > * VACUUM > > Maybe set a breakpoint on sqlite3ResetInternalSchema() to find out what is > making the schema be reparsed so much. > > > > > > Times calling _malloc: 2,775,682 > > sqlite3RunParser(9) > > sqlite3Prepare(8) > > sqlite3_prepare(7) > > sqlite3_exec_inner_loop_invoke_callback(6) > > sqlite3_exec_outer_while(5) > > sqlite3_exec(4) > > sqlite3Parser(3) > > sqlite3RunParser(2) > > sqlite3Prepare(1) > > sqlite3_step(0) > > > > Times calling _malloc: 2,775,682 > > sqlite3Prepare(8) > > sqlite3_prepare(7) > > sqlite3_exec_inner_loop_invoke_callback(6) > > sqlite3_exec_outer_while(5) > > sqlite3_exec(4) > > sqlite3Parser(3) > > sqlite3RunParser(2) > > sqlite3Prepare(1) > > sqlite3_step(0) > > > > Times calling _malloc: 2,092,350 > > sqlite3Parser(3) > > sqlite3RunParser(2) > > sqlite3Prepare(1) > > sqlite3_step(0) > > _______________________________________________ > > 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 > -- 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
