You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
When hitting an endpoint, the server is generating multiple SQL queries for each spell in the result set. This is because data linked through a foreign key is being accessed without telling django that it will be used.
When hitting https://api.open5e.com/v2/spells, 203 queries are generated.
When hitting https://api.open5e.com/v2/spells?depth=1, 253 queries are generated.
This is probably an issue with more than just spells, and is probably happening for other endpoints.
This is the classic N+1 problem, where the server is generating multiple queries.
The text was updated successfully, but these errors were encountered:
When hitting an endpoint, the server is generating multiple SQL queries for each spell in the result set. This is because data linked through a foreign key is being accessed without telling django that it will be used.
When hitting
https://api.open5e.com/v2/spells
, 203 queries are generated.When hitting
https://api.open5e.com/v2/spells?depth=1
, 253 queries are generated.This is probably an issue with more than just spells, and is probably happening for other endpoints.
This is the classic N+1 problem, where the server is generating multiple queries.
The text was updated successfully, but these errors were encountered: