-
Bug
-
Resolution: Fixed
-
Normal
-
None
-
None
The *_gid_redirect tables used to be used only for lookups by MBID, for which there is an index due to the MBID (gid column) being the primary key. However, now there is a load_gid_redirects method for JSON-LD that queries these tables by new_id instead, requiring a sequential scan of the whole table (since the 2015-01-12 release). Indexes on that column need to be added.
- is related to
-
MBS-3946 Webservice should return all MBIDs for entities which have multiple MBIDs (e.g. from merging)
-
- Open
-
Missing indexes for inverse lookup on *_gid_redirect tables
-
-
Resolution: Fixed
-
Normal
-
None
-
None
The *_gid_redirect tables used to be used only for lookups by MBID, for which there is an index due to the MBID (gid column) being the primary key. However, now there is a load_gid_redirects method for JSON-LD that queries these tables by new_id instead, requiring a sequential scan of the whole table (since the 2015-01-12 release). Indexes on that column need to be added.
- is related to
-
-
- Open
-
-
Roman
-
- Votes:
-
0 Vote for this issue
- Watchers:
-
0 Start watching this issue
- Created:
- Updated:
- Resolved:
| Version | Package |
|---|---|
| Schema change, 2016-05-23 |