Performance problem on /Hints/AuthorIndex

[morganbr]

AuthorIndex is making an individual SQL call for each hint and puzzle on the page. It needs to be using an inner join instead (see Morgan for more details).

_MS.ProcessedByMetricExtractors: (Name:'Requests', Ver:'1.0')
Account Id:
Application version: 1.0.0.0
AspNetCoreEnvironment: Production
Auth user Id:
Browser version:
City: DuPont
Client IP address: 0.0.0.0
Cloud role instance: RD0003FFE533C6
Cloud role name: puzzlehunt
Country or region: United States
Device model:
Device type: PC
Event time: 4/6/2019, 11:31:40 PM
Operating system:
Operation Id: f344a7a5-46c7920e0b421245
Operation name: GET /Hints/AuthorIndex
Parent Id: f344a7a5-46c7920e0b421245
Request Id: |f344a7a5-46c7920e0b421245.
Request name: GET /Hints/AuthorIndex
Request source:
Request URL: https://puzzlehunt.azurewebsites.net/1/author/Hints/AuthorIndex
Response code: 200
Response time: 15.07 s
Sample Rate: 20
SDK version: aspnet5c:2.3.0
Session Id: pH03J
Source of synthetic traffic:
State or province: Washington
Successful request: true
Telemetry type: request
User Id: bklL8

View this instance in the Azure portal<\a>