PuzzleServer / mainpuzzleserver

The main repo for the Puzzle Hunt and Puzzleday servers.
MIT License
9 stars 31 forks source link

Play page doing many puzzle queries #418

Closed morganbr closed 5 years ago

morganbr commented 5 years ago

The puzzle play page is doing almost as many queries for a puzzle as there are puzzles in an event, whether they're locked or unlocked. It might be querying per puzzle file.

MS.ProcessedByMetricExtractors: (Name:'Dependencies', Ver:'1.1') Account Id: Application version: 1.0.0.0 AspNetCoreEnvironment: Production Auth user Id: Base name: tcp:puzzlehunt.database.windows.net,1433 | puzzleserver Browser version: City: Portland Client IP address: 0.0.0.0 Cloud role instance: RD281878718BB9 Cloud role name: puzzlehunt Country or region: United States Dependency duration: 0 Dependency Id: 766d99075cd54e4194fb02f404a71c2f Dependency name: SQL: tcp:puzzlehunt.database.windows.net,1433 | puzzleserver Dependency type: SQL Device model: Device type: PC Event time: 4/25/2019, 7:46:13 PM Operating system: Operation Id: b53659acfb571f4590126cb4289cc566 Operation name: GET /Teams/Play Parent Id: |b53659acfb571f4590126cb4289cc566.e792f468 Result code: Sample Rate: 25 SDK version: rdddsc:2.9.1-26132 Session Id: jvjeu Source of synthetic traffic: State or province: Oregon Successful call: true Telemetry type: dependency User Id: 1ZrL6

morganbr commented 5 years ago

Fixed in #423