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
We've been gradually tracking down / fixing N+1 queries via joins() and includes(). One are not tackled yet: link counts. For our internal users with 100s of accounts (ad-ops, support), this can be prohibitively slow.
Options:
Tackle this with with caching (first query could still be real slow)
Write a bunch of custom SQL to eager-load and hydrate those counts
Use a query param similar to "zoom" to indicate if you want the counts returned or not
Just remove counts from all the links (and fix Publish to work with that ... making a 2nd GET if it needs the count)
The text was updated successfully, but these errors were encountered:
We've been gradually tracking down / fixing N+1 queries via
joins()
andincludes()
. One are not tackled yet: link counts. For our internal users with 100s of accounts (ad-ops, support), this can be prohibitively slow.Options:
The text was updated successfully, but these errors were encountered: