osmcha-frontend icon indicating copy to clipboard operation
osmcha-frontend copied to clipboard

Improve user-stats SQL query

Open willemarcel opened this issue 3 years ago • 0 comments

The /user-stats/{uid}/ endpoint is failing or taking a long time for users with thousands changesets registered in OSMCha. The SQL query can be optimized in order to make it work.

https://github.com/willemarcel/osmcha-django/blob/master/osmchadjango/changeset/views.py#L542

willemarcel avatar Jan 06 '22 21:01 willemarcel