On Tue, Jan 24, 2012 at 1:18 PM, Dan Kennedy <danielk1...@gmail.com> wrote:
> 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.elrick@fenestra.**com<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. > > Unfortunately, no I cannot. Delphi 2007 doesn't give me accurate information from a linked OBJ. It's roughly equivalent to trying to get accurate call stacks from inside a DLL. I've had to hand add pseudo call stack information. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
