On Tue, Jan 24, 2012 at 12:53 PM, Richard Hipp <d...@sqlite.org> wrote:
> On Tue, Jan 24, 2012 at 12:15 PM, John Elrick <john.elr...@fenestra.com > >wrote: > > > > > > > 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. > Richard, I added some tracking which keeps a log of every query and writes the last 50 things done when the call to sqlite3ResetInternalSchema() takes place. Here is a fairly representative entry. The last SQL is the one which triggered the call to sqlite3ResetInternalSchema(). Nothing here which touches the schema of the database that I can see. last 50 sqls = 'step: select distinct RESPONSES.RESPONSE_OID from RESPONSES, DATA_ELEMENTS, SEQUENCE_ELEMENTS where SEQUENCE_ELEMENTS.SEQUENCE_ELEMENT_OID=:SEQUENCE_ELEMENTS_SEQUENCE_ELEMENT_OID and DATA_ELEMENTS.DATA_ELEMENT_NAME=:DATA_ELEMENTS_DATA_ELEMENT_NAME and RESPONSES.instance_parent=SEQUENCE_ELEMENTS.SEQUENCE_ELEMENT_OID and RESPONSES.definition_parent=DATA_ELEMENTS.DATA_ELEMENT_OID order by RESPONSES.rowid step: SELECT * FROM RESPONSES a where a.soft_deleted_char = 'F' and a.RESPONSE_OID = :oid step: UPDATE RESPONSES SET RESPONSE_NAME = :RESPONSE_NAME, prelisted_value = :prelisted_value WHERE RESPONSE_OID = :RESPONSE_OID step: select distinct DATA_ELEMENTS.DATA_ELEMENT_OID from RESPONSES, DATA_ELEMENTS, SEQUENCE_ELEMENTS where SEQUENCE_ELEMENTS.SEQUENCE_ELEMENT_OID=:SEQUENCE_ELEMENTS_SEQUENCE_ELEMENT_OID and DATA_ELEMENTS.DATA_ELEMENT_NAME=:DATA_ELEMENTS_DATA_ELEMENT_NAME and RESPONSES.instance_parent=SEQUENCE_ELEMENTS.SEQUENCE_ELEMENT_OID and RESPONSES.definition_parent=DATA_ELEMENTS.DATA_ELEMENT_OID order by DATA_ELEMENTS.rowid step: select distinct DATA_ELEMENTS.DATA_ELEMENT_OID from RESPONSES, DATA_ELEMENTS, SEQUENCE_ELEMENTS where SEQUENCE_ELEMENTS.SEQUENCE_ELEMENT_OID=:SEQUENCE_ELEMENTS_SEQUENCE_ELEMENT_OID and DATA_ELEMENTS.DATA_ELEMENT_NAME=:DATA_ELEMENTS_DATA_ELEMENT_NAME and RESPONSES.instance_parent=SEQUENCE_ELEMENTS.SEQUENCE_ELEMENT_OID and RESPONSES.definition_parent=DATA_ELEMENTS.DATA_ELEMENT_OID order by DATA_ELEMENTS.rowid step: select distinct RESPONSES.RESPONSE_OID from RESPONSES, DATA_ELEMENTS, SEQUENCE_ELEMENTS where SEQUENCE_ELEMENTS.SEQUENCE_ELEMENT_OID=:SEQUENCE_ELEMENTS_SEQUENCE_ELEMENT_OID and DATA_ELEMENTS.DATA_ELEMENT_NAME=:DATA_ELEMENTS_DATA_ELEMENT_NAME and RESPONSES.instance_parent=SEQUENCE_ELEMENTS.SEQUENCE_ELEMENT_OID and RESPONSES.definition_parent=DATA_ELEMENTS.DATA_ELEMENT_OID order by RESPONSES.rowid step: select distinct RESPONSES.RESPONSE_OID from RESPONSES, DATA_ELEMENTS, SEQUENCE_ELEMENTS where SEQUENCE_ELEMENTS.SEQUENCE_ELEMENT_OID=:SEQUENCE_ELEMENTS_SEQUENCE_ELEMENT_OID and DATA_ELEMENTS.DATA_ELEMENT_NAME=:DATA_ELEMENTS_DATA_ELEMENT_NAME and RESPONSES.instance_parent=SEQUENCE_ELEMENTS.SEQUENCE_ELEMENT_OID and RESPONSES.definition_parent=DATA_ELEMENTS.DATA_ELEMENT_OID order by RESPONSES.rowid step: SELECT * FROM RESPONSES a where a.soft_deleted_char = 'F' and a.RESPONSE_OID = :oid step: UPDATE RESPONSES SET RESPONSE_NAME = :RESPONSE_NAME, prelisted_value = :prelisted_value WHERE RESPONSE_OID = :RESPONSE_OID step: select distinct DATA_ELEMENTS.DATA_ELEMENT_OID from RESPONSES, DATA_ELEMENTS, SEQUENCE_ELEMENTS where SEQUENCE_ELEMENTS.SEQUENCE_ELEMENT_OID=:SEQUENCE_ELEMENTS_SEQUENCE_ELEMENT_OID and DATA_ELEMENTS.DATA_ELEMENT_NAME=:DATA_ELEMENTS_DATA_ELEMENT_NAME and RESPONSES.instance_parent=SEQUENCE_ELEMENTS.SEQUENCE_ELEMENT_OID and RESPONSES.definition_parent=DATA_ELEMENTS.DATA_ELEMENT_OID order by DATA_ELEMENTS.rowid step: select distinct DATA_ELEMENTS.DATA_ELEMENT_OID from RESPONSES, DATA_ELEMENTS, SEQUENCE_ELEMENTS where SEQUENCE_ELEMENTS.SEQUENCE_ELEMENT_OID=:SEQUENCE_ELEMENTS_SEQUENCE_ELEMENT_OID and DATA_ELEMENTS.DATA_ELEMENT_NAME=:DATA_ELEMENTS_DATA_ELEMENT_NAME and RESPONSES.instance_parent=SEQUENCE_ELEMENTS.SEQUENCE_ELEMENT_OID and RESPONSES.definition_parent=DATA_ELEMENTS.DATA_ELEMENT_OID order by DATA_ELEMENTS.rowid step: select distinct RESPONSES.RESPONSE_OID from RESPONSES, DATA_ELEMENTS, SEQUENCE_ELEMENTS where SEQUENCE_ELEMENTS.SEQUENCE_ELEMENT_OID=:SEQUENCE_ELEMENTS_SEQUENCE_ELEMENT_OID and DATA_ELEMENTS.DATA_ELEMENT_NAME=:DATA_ELEMENTS_DATA_ELEMENT_NAME and RESPONSES.instance_parent=SEQUENCE_ELEMENTS.SEQUENCE_ELEMENT_OID and RESPONSES.definition_parent=DATA_ELEMENTS.DATA_ELEMENT_OID order by RESPONSES.rowid step: select distinct RESPONSES.RESPONSE_OID from RESPONSES, DATA_ELEMENTS, SEQUENCE_ELEMENTS where SEQUENCE_ELEMENTS.SEQUENCE_ELEMENT_OID=:SEQUENCE_ELEMENTS_SEQUENCE_ELEMENT_OID and DATA_ELEMENTS.DATA_ELEMENT_NAME=:DATA_ELEMENTS_DATA_ELEMENT_NAME and RESPONSES.instance_parent=SEQUENCE_ELEMENTS.SEQUENCE_ELEMENT_OID and RESPONSES.definition_parent=DATA_ELEMENTS.DATA_ELEMENT_OID order by RESPONSES.rowid step: SELECT * FROM RESPONSES a where a.soft_deleted_char = 'F' and a.RESPONSE_OID = :oid step: UPDATE RESPONSES SET RESPONSE_NAME = :RESPONSE_NAME, prelisted_value = :prelisted_value WHERE RESPONSE_OID = :RESPONSE_OID step: select distinct DATA_ELEMENTS.DATA_ELEMENT_OID from RESPONSES, DATA_ELEMENTS, SEQUENCE_ELEMENTS where SEQUENCE_ELEMENTS.SEQUENCE_ELEMENT_OID=:SEQUENCE_ELEMENTS_SEQUENCE_ELEMENT_OID and DATA_ELEMENTS.DATA_ELEMENT_NAME=:DATA_ELEMENTS_DATA_ELEMENT_NAME and RESPONSES.instance_parent=SEQUENCE_ELEMENTS.SEQUENCE_ELEMENT_OID and RESPONSES.definition_parent=DATA_ELEMENTS.DATA_ELEMENT_OID order by DATA_ELEMENTS.rowid step: select distinct DATA_ELEMENTS.DATA_ELEMENT_OID from RESPONSES, DATA_ELEMENTS, SEQUENCE_ELEMENTS where SEQUENCE_ELEMENTS.SEQUENCE_ELEMENT_OID=:SEQUENCE_ELEMENTS_SEQUENCE_ELEMENT_OID and DATA_ELEMENTS.DATA_ELEMENT_NAME=:DATA_ELEMENTS_DATA_ELEMENT_NAME and RESPONSES.instance_parent=SEQUENCE_ELEMENTS.SEQUENCE_ELEMENT_OID and RESPONSES.definition_parent=DATA_ELEMENTS.DATA_ELEMENT_OID order by DATA_ELEMENTS.rowid step: select distinct RESPONSES.RESPONSE_OID from RESPONSES, DATA_ELEMENTS, SEQUENCE_ELEMENTS where SEQUENCE_ELEMENTS.SEQUENCE_ELEMENT_OID=:SEQUENCE_ELEMENTS_SEQUENCE_ELEMENT_OID and DATA_ELEMENTS.DATA_ELEMENT_NAME=:DATA_ELEMENTS_DATA_ELEMENT_NAME and RESPONSES.instance_parent=SEQUENCE_ELEMENTS.SEQUENCE_ELEMENT_OID and RESPONSES.definition_parent=DATA_ELEMENTS.DATA_ELEMENT_OID order by RESPONSES.rowid step: select distinct RESPONSES.RESPONSE_OID from RESPONSES, DATA_ELEMENTS, SEQUENCE_ELEMENTS where SEQUENCE_ELEMENTS.SEQUENCE_ELEMENT_OID=:SEQUENCE_ELEMENTS_SEQUENCE_ELEMENT_OID and DATA_ELEMENTS.DATA_ELEMENT_NAME=:DATA_ELEMENTS_DATA_ELEMENT_NAME and RESPONSES.instance_parent=SEQUENCE_ELEMENTS.SEQUENCE_ELEMENT_OID and RESPONSES.definition_parent=DATA_ELEMENTS.DATA_ELEMENT_OID order by RESPONSES.rowid step: SELECT * FROM RESPONSES a where a.soft_deleted_char = 'F' and a.RESPONSE_OID = :oid step: UPDATE RESPONSES SET RESPONSE_NAME = :RESPONSE_NAME, prelisted_value = :prelisted_value WHERE RESPONSE_OID = :RESPONSE_OID step: select distinct DATA_ELEMENTS.DATA_ELEMENT_OID from RESPONSES, DATA_ELEMENTS, SEQUENCE_ELEMENTS where SEQUENCE_ELEMENTS.SEQUENCE_ELEMENT_OID=:SEQUENCE_ELEMENTS_SEQUENCE_ELEMENT_OID and DATA_ELEMENTS.DATA_ELEMENT_NAME=:DATA_ELEMENTS_DATA_ELEMENT_NAME and RESPONSES.instance_parent=SEQUENCE_ELEMENTS.SEQUENCE_ELEMENT_OID and RESPONSES.definition_parent=DATA_ELEMENTS.DATA_ELEMENT_OID order by DATA_ELEMENTS.rowid step: select distinct DATA_ELEMENTS.DATA_ELEMENT_OID from RESPONSES, DATA_ELEMENTS, SEQUENCE_ELEMENTS where SEQUENCE_ELEMENTS.SEQUENCE_ELEMENT_OID=:SEQUENCE_ELEMENTS_SEQUENCE_ELEMENT_OID and DATA_ELEMENTS.DATA_ELEMENT_NAME=:DATA_ELEMENTS_DATA_ELEMENT_NAME and RESPONSES.instance_parent=SEQUENCE_ELEMENTS.SEQUENCE_ELEMENT_OID and RESPONSES.definition_parent=DATA_ELEMENTS.DATA_ELEMENT_OID order by DATA_ELEMENTS.rowid step: select distinct RESPONSES.RESPONSE_OID from RESPONSES, DATA_ELEMENTS, SEQUENCE_ELEMENTS where SEQUENCE_ELEMENTS.SEQUENCE_ELEMENT_OID=:SEQUENCE_ELEMENTS_SEQUENCE_ELEMENT_OID and DATA_ELEMENTS.DATA_ELEMENT_NAME=:DATA_ELEMENTS_DATA_ELEMENT_NAME and RESPONSES.instance_parent=SEQUENCE_ELEMENTS.SEQUENCE_ELEMENT_OID and RESPONSES.definition_parent=DATA_ELEMENTS.DATA_ELEMENT_OID order by RESPONSES.rowid step: select distinct RESPONSES.RESPONSE_OID from RESPONSES, DATA_ELEMENTS, SEQUENCE_ELEMENTS where SEQUENCE_ELEMENTS.SEQUENCE_ELEMENT_OID=:SEQUENCE_ELEMENTS_SEQUENCE_ELEMENT_OID and DATA_ELEMENTS.DATA_ELEMENT_NAME=:DATA_ELEMENTS_DATA_ELEMENT_NAME and RESPONSES.instance_parent=SEQUENCE_ELEMENTS.SEQUENCE_ELEMENT_OID and RESPONSES.definition_parent=DATA_ELEMENTS.DATA_ELEMENT_OID order by RESPONSES.rowid step: SELECT * FROM RESPONSES a where a.soft_deleted_char = 'F' and a.RESPONSE_OID = :oid step: UPDATE RESPONSES SET RESPONSE_NAME = :RESPONSE_NAME, prelisted_value = :prelisted_value WHERE RESPONSE_OID = :RESPONSE_OID step: select distinct DATA_ELEMENTS.DATA_ELEMENT_OID from RESPONSES, DATA_ELEMENTS, SEQUENCE_ELEMENTS where SEQUENCE_ELEMENTS.SEQUENCE_ELEMENT_OID=:SEQUENCE_ELEMENTS_SEQUENCE_ELEMENT_OID and DATA_ELEMENTS.DATA_ELEMENT_NAME=:DATA_ELEMENTS_DATA_ELEMENT_NAME and RESPONSES.instance_parent=SEQUENCE_ELEMENTS.SEQUENCE_ELEMENT_OID and RESPONSES.definition_parent=DATA_ELEMENTS.DATA_ELEMENT_OID order by DATA_ELEMENTS.rowid step: select distinct DATA_ELEMENTS.DATA_ELEMENT_OID from RESPONSES, DATA_ELEMENTS, SEQUENCE_ELEMENTS where SEQUENCE_ELEMENTS.SEQUENCE_ELEMENT_OID=:SEQUENCE_ELEMENTS_SEQUENCE_ELEMENT_OID and DATA_ELEMENTS.DATA_ELEMENT_NAME=:DATA_ELEMENTS_DATA_ELEMENT_NAME and RESPONSES.instance_parent=SEQUENCE_ELEMENTS.SEQUENCE_ELEMENT_OID and RESPONSES.definition_parent=DATA_ELEMENTS.DATA_ELEMENT_OID order by DATA_ELEMENTS.rowid step: select distinct RESPONSES.RESPONSE_OID from RESPONSES, DATA_ELEMENTS, SEQUENCE_ELEMENTS where SEQUENCE_ELEMENTS.SEQUENCE_ELEMENT_OID=:SEQUENCE_ELEMENTS_SEQUENCE_ELEMENT_OID and DATA_ELEMENTS.DATA_ELEMENT_NAME=:DATA_ELEMENTS_DATA_ELEMENT_NAME and RESPONSES.instance_parent=SEQUENCE_ELEMENTS.SEQUENCE_ELEMENT_OID and RESPONSES.definition_parent=DATA_ELEMENTS.DATA_ELEMENT_OID order by RESPONSES.rowid step: select distinct RESPONSES.RESPONSE_OID from RESPONSES, DATA_ELEMENTS, SEQUENCE_ELEMENTS where SEQUENCE_ELEMENTS.SEQUENCE_ELEMENT_OID=:SEQUENCE_ELEMENTS_SEQUENCE_ELEMENT_OID and DATA_ELEMENTS.DATA_ELEMENT_NAME=:DATA_ELEMENTS_DATA_ELEMENT_NAME and RESPONSES.instance_parent=SEQUENCE_ELEMENTS.SEQUENCE_ELEMENT_OID and RESPONSES.definition_parent=DATA_ELEMENTS.DATA_ELEMENT_OID order by RESPONSES.rowid step: SELECT * FROM RESPONSES a where a.soft_deleted_char = 'F' and a.RESPONSE_OID = :oid step: UPDATE RESPONSES SET RESPONSE_NAME = :RESPONSE_NAME, prelisted_value = :prelisted_value WHERE RESPONSE_OID = :RESPONSE_OID step: select distinct DATA_ELEMENTS.DATA_ELEMENT_OID from RESPONSES, DATA_ELEMENTS, SEQUENCE_ELEMENTS where SEQUENCE_ELEMENTS.SEQUENCE_ELEMENT_OID=:SEQUENCE_ELEMENTS_SEQUENCE_ELEMENT_OID and DATA_ELEMENTS.DATA_ELEMENT_NAME=:DATA_ELEMENTS_DATA_ELEMENT_NAME and RESPONSES.instance_parent=SEQUENCE_ELEMENTS.SEQUENCE_ELEMENT_OID and RESPONSES.definition_parent=DATA_ELEMENTS.DATA_ELEMENT_OID order by DATA_ELEMENTS.rowid step: select distinct DATA_ELEMENTS.DATA_ELEMENT_OID from RESPONSES, DATA_ELEMENTS, SEQUENCE_ELEMENTS where SEQUENCE_ELEMENTS.SEQUENCE_ELEMENT_OID=:SEQUENCE_ELEMENTS_SEQUENCE_ELEMENT_OID and DATA_ELEMENTS.DATA_ELEMENT_NAME=:DATA_ELEMENTS_DATA_ELEMENT_NAME and RESPONSES.instance_parent=SEQUENCE_ELEMENTS.SEQUENCE_ELEMENT_OID and RESPONSES.definition_parent=DATA_ELEMENTS.DATA_ELEMENT_OID order by DATA_ELEMENTS.rowid prepare: UPDATE RESPONSES SET prelisted_value = :prelisted_value WHERE RESPONSE_OID = :RESPONSE_OID step: UPDATE RESPONSES SET prelisted_value = :prelisted_value WHERE RESPONSE_OID = :RESPONSE_OID step: select distinct DATA_ELEMENTS.DATA_ELEMENT_OID from RESPONSES, DATA_ELEMENTS, SEQUENCE_ELEMENTS where SEQUENCE_ELEMENTS.SEQUENCE_ELEMENT_OID=:SEQUENCE_ELEMENTS_SEQUENCE_ELEMENT_OID and DATA_ELEMENTS.DATA_ELEMENT_NAME=:DATA_ELEMENTS_DATA_ELEMENT_NAME and RESPONSES.instance_parent=SEQUENCE_ELEMENTS.SEQUENCE_ELEMENT_OID and RESPONSES.definition_parent=DATA_ELEMENTS.DATA_ELEMENT_OID order by DATA_ELEMENTS.rowid step: select distinct DATA_ELEMENTS.DATA_ELEMENT_OID from RESPONSES, DATA_ELEMENTS, SEQUENCE_ELEMENTS where SEQUENCE_ELEMENTS.SEQUENCE_ELEMENT_OID=:SEQUENCE_ELEMENTS_SEQUENCE_ELEMENT_OID and DATA_ELEMENTS.DATA_ELEMENT_NAME=:DATA_ELEMENTS_DATA_ELEMENT_NAME and RESPONSES.instance_parent=SEQUENCE_ELEMENTS.SEQUENCE_ELEMENT_OID and RESPONSES.definition_parent=DATA_ELEMENTS.DATA_ELEMENT_OID order by DATA_ELEMENTS.rowid step: select distinct RESPONSES.RESPONSE_OID from RESPONSES, DATA_ELEMENTS, SEQUENCE_ELEMENTS where SEQUENCE_ELEMENTS.SEQUENCE_ELEMENT_OID=:SEQUENCE_ELEMENTS_SEQUENCE_ELEMENT_OID and DATA_ELEMENTS.DATA_ELEMENT_NAME=:DATA_ELEMENTS_DATA_ELEMENT_NAME and RESPONSES.instance_parent=SEQUENCE_ELEMENTS.SEQUENCE_ELEMENT_OID and RESPONSES.definition_parent=DATA_ELEMENTS.DATA_ELEMENT_OID order by RESPONSES.rowid step: select distinct RESPONSES.RESPONSE_OID from RESPONSES, DATA_ELEMENTS, SEQUENCE_ELEMENTS where SEQUENCE_ELEMENTS.SEQUENCE_ELEMENT_OID=:SEQUENCE_ELEMENTS_SEQUENCE_ELEMENT_OID and DATA_ELEMENTS.DATA_ELEMENT_NAME=:DATA_ELEMENTS_DATA_ELEMENT_NAME and RESPONSES.instance_parent=SEQUENCE_ELEMENTS.SEQUENCE_ELEMENT_OID and RESPONSES.definition_parent=DATA_ELEMENTS.DATA_ELEMENT_OID order by RESPONSES.rowid step: SELECT * FROM RESPONSES a where a.soft_deleted_char = 'F' and a.RESPONSE_OID = :oid step: UPDATE RESPONSES SET RESPONSE_NAME = :RESPONSE_NAME, prelisted_value = :prelisted_value WHERE RESPONSE_OID = :RESPONSE_OID prepare: select max(SURVEY_OID) from SURVEYS step: select max(SURVEY_OID) from SURVEYS step: select distinct MANIFESTS.MANIFEST_OID from MANIFESTS order by MANIFESTS.rowid step: select distinct MANIFESTS.MANIFEST_OID from MANIFESTS order by MANIFESTS.rowid prepare: select max(SURVEY_OID) from SURVEYS step: select max(SURVEY_OID) from SURVEYS step: select distinct SURVEYS.SURVEY_OID from MANIFESTS, SURVEYS where MANIFESTS.MANIFEST_OID=:MANIFESTS_MANIFEST_OID and MANIFESTS.definition_parent=SURVEYS.SURVEY_OID order by SURVEYS.rowid' _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users