Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Improve performance when loading a subset of tags with stats #2084

Open
acelaya opened this issue Apr 1, 2024 · 0 comments
Open

Improve performance when loading a subset of tags with stats #2084

acelaya opened this issue Apr 1, 2024 · 0 comments

Comments

@acelaya
Copy link
Member

acelaya commented Apr 1, 2024

After a long time with hard to solve performance issues in the tags with stats endpoint, this has been drastically improved thanks to the introduction of the short_urls_visits_counts table (see #2074 and #2078).

However, the query is still complex, requiring a native query builder, and performance does not improve a lot when fetching only a subset of tags, compared to fetching the whole list.

The fact that fetching the whole list is now quite fast, makes this a non-critical issue, but it is a bit unintuitive that fetching the whole list and paginating client-side is still better than paginating server-side.

It would be useful to put some though on this and try to improve that query.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
Status: No status
Development

No branches or pull requests

1 participant