thunderdome-planning-poker: Bug: My Games overview has an error
List of /games is and stays empty.
ERR poker/client.go:87 > | ts=1711586159.74078 msg=close error version=3.8.3 error=close tcp 172.17.0.6:8080->172.17.0.1:42525: use of closed network connection poker_id=22fc1095-527c-429d-823b-caa99150cfc1 session_user_id=d3ce7a1d-9bfa-422c-b05d-225380e7cc0e stacktrace=github.com/StevenWeathers/thunderdome-planning-poker/internal/http/poker.subscription.readPump.func1
/home/runner/work/thunderdome-planning-poker/thunderdome-planning-poker/internal/http/poker/client.go:87
github.com/StevenWeathers/thunderdome-planning-poker/internal/http/poker.subscription.readPump
/home/runner/work/thunderdome-planning-poker/thunderdome-planning-poker/internal/http/poker/client.go:153
About this issue
- Original URL
- State: closed
- Created 3 years ago
- Comments: 30 (14 by maintainers)
Commits related to this issue
- Refactor the GetGamesByUser query to improve performance Fixes #533 — committed to StevenWeathers/thunderdome-planning-poker by StevenWeathers 3 years ago
- Refactor the GetGamesByUser query to improve performance (#543) * Refactor the GetGamesByUser query to improve performance Fixes #533 * Add desc order direction back into GetGamesByUser query — committed to StevenWeathers/thunderdome-planning-poker by StevenWeathers 3 years ago
If you could give this a shot replace
USER_ID_HEREand let me know your performance.I’m playing with the Query and have the number of rows way down, still trying to optimize further.
Ok I see what’s going on, its the poker_user join thats actually increasing the query scans.
Good news is you can increase the http timeouts in the short term, currently the default is 5 seconds.
Ok so that the team_user table does not have an index on the team_id column, that could improve performance for a larger table of users.