Symmetrically to T1073, we need to stop using temporary table for reading data.
Description
Description
Revisions and Commits
Revisions and Commits
Related Objects
Related Objects
| Status | Assigned | Task | ||
|---|---|---|---|---|
| Migrated | gitlab-migration | T1173 Huge slowdowns on louvre since 2018-08-20 | ||
| Migrated | gitlab-migration | T1069 fully host the web UI on Azure | ||
| Migrated | gitlab-migration | T1094 swh-indexer db replica on azure | ||
| Migrated | gitlab-migration | T1095 indexer: Remove temporary table usage for read-only queries |
- Mentioned In
- rDCIDX6b97d704003a: swh.indexer.storage.db: Refactor using a `get from list` pattern
rDCIDXf4d034a35f48: storage: revision_metadata_get: Migrate away from temp table
rDCIDXf4f2febbb196: swh.indexer.storage.db: Refactor using a `missing from list` pattern
rDCIDXedb02b574f86: storage: revision_metadata_missing: Migrate away from temp table
rDCIDX59be2043e91c: swh.indexer.storage: Update docstrings information and format
rDCIDXfd985db8c6a5: storage: c_fossology_license_get: Migrate away from temp table
rDCIDX557c8e8b8120: storage: content_metadata_get: Migrate away from temp table
rDCIDXe6f7a58b060b: storage: content_metadata_missing: Migrate away from temp table
rDCIDX1f775de94b42: storage: content_ctags_missing: Migrate away from temp table
rDCIDX09787cc0e518: storage: content_language_get: Migrate away from temp table
rDCIDX2ea969f1f144: storage: content_ctags_get: Migrate away from temp table
rDCIDX7f39bb2f9aec: storage: content_mimetype_get: Migrate away from temp table
rDCIDX6c0ed97ac4de: storage: content_language_missing: Migrate away from temp table
rDCIDX740d0fe8f6d3: storage: content_mimetype_missing: Migrate away from temp table - Mentioned Here
- T1073: Remove temporary table usage for read-only queries
Event Timeline
ardumont created this task.
ardumont mentioned this in rDCIDX740d0fe8f6d3: storage: content_mimetype_missing: Migrate away from temp table.Jun 13 2018, 11:26 AM2018-06-13 11:26:07 (UTC+2)
ardumont mentioned this in rDCIDX7f39bb2f9aec: storage: content_mimetype_get: Migrate away from temp table.
ardumont mentioned this in rDCIDX6c0ed97ac4de: storage: content_language_missing: Migrate away from temp table.
ardumont mentioned this in rDCIDX09787cc0e518: storage: content_language_get: Migrate away from temp table.
ardumont mentioned this in rDCIDX1f775de94b42: storage: content_ctags_missing: Migrate away from temp table.
ardumont mentioned this in rDCIDX2ea969f1f144: storage: content_ctags_get: Migrate away from temp table.
ardumont mentioned this in rDCIDXfd985db8c6a5: storage: c_fossology_license_get: Migrate away from temp table.
ardumont mentioned this in rDCIDXe6f7a58b060b: storage: content_metadata_missing: Migrate away from temp table.
ardumont mentioned this in rDCIDX557c8e8b8120: storage: content_metadata_get: Migrate away from temp table.
ardumont mentioned this in rDCIDX59be2043e91c: swh.indexer.storage: Update docstrings information and format.
ardumont mentioned this in rDCIDXedb02b574f86: storage: revision_metadata_missing: Migrate away from temp table.
ardumont mentioned this in rDCIDXf4d034a35f48: storage: revision_metadata_get: Migrate away from temp table.
gitlab-migration changed the task status from Resolved to Migrated.Oct 19 2022, 5:53 PM2022-10-19 17:53:56 (UTC+2)
gitlab-migration claimed this task.
Comment Actions