On 01/25/2012 12:15 AM, John Elrick wrote:
On Tue, Jan 24, 2012 at 12:06 PM, Richard Hipp<d...@sqlite.org> wrote:
On Tue, Jan 24, 2012 at 11:59 AM, John Elrick<john.elr...@fenestra.com
wrote:
While reviewing our other thread, I noticed a piece of information
concerning sqlite3ResetInternalSchema. Based on the number of times
that I
reported it had been called, I believe that something was changed between
3.7.5 and 3.7.6 which causes sqlite3ResetInternalSchema to be called when
it wasn't in the earlier version. Is there some kind of enumeration of
what events would cause sqlite3ResetInternalSchema to be called in
version
3.7.5 vs 3.7.6?
I agree that the fact that the triggers are being reparsed is a big hint.
But we still don't know why they are being reparsed. And we still cannot
reproduce the problem in a command-line shell - in only seems to occur
within your Delphi app.
Can you put a breakpoint on sqlite3ResetInternalSchema() and figure out
from whence it is being called so often?
Just did. Most of the calls are bubbling up from _sqlite3_step which I
mentioned before.
Can you see the whole call stack? There are a couple of different
ways sqlite3ResetInternalSchema() may be called from within
sqlite3_step(). Knowing which will be a clue as to why it is being
called.
Dan.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
