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?


> _______________________________________________
> 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

Reply via email to