What is triggering execution of specific SQL statement against RTC backen db?
Hi,
I see the following SQL statement being executed several times a day on the RTC backend db. What is the action that triggers this SQL statement to run? Is it a user accessing specific source code in their RTC Project? SELECT SEQUENCE_COL, STORED_SIZE, EXPANDED_SIZE, STORAGE_METHOD, DELTA_PREDECESSOR, CONTENT_BYTES FROM SCM.CONTENT WHERE HASH_CODE = ? ORDER BY SEQUENCE_COL ASC |
One answer
This is the query used by the server to fetch content from the db.
User actions that retrieve file contents from the server would hit this: loading workspaces, accepting changesets into a loaded workspace, doing compares, etc. I don't think a user accessing specific source code in their RTC project would necessarily trigger this since the user should have the content locally in their sandbox. |
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.