Site timeout

[benmccann]

Thank you sooo much for this service! We've been using it to remove unnecessary dependencies and have already removed billions of monthly downloads from the npm registry

I'd like to find more usages of this package, but the page is timing out:
https://packages.ecosyste.ms/registries/npmjs.org/packages/rimraf/dependent_packages?kind=runtime&latest=true&order=desc&sort=downloads

[andrew]

I’ll take a look tomorrow, I suspect it’s missing a db index on the kind filter counting.

In the meantime you can use the api end point, which loads faster: https://packages.ecosyste.ms/api/v1/registries/npmjs.org/packages/rimraf/dependent_packages?kind=runtime&latest=true&order=desc&sort=downloads

[andrew]

It's definitely related to the kind query as https://packages.ecosyste.ms/api/v1/registries/npmjs.org/packages/rimraf/dependent_package_kinds?latest=true times at as well.

Need to optimze the query and add some caching in (the counts don't change that regularly)