Skip to content
This repository has been archived by the owner on Feb 8, 2018. It is now read-only.

Speed up /about/stats #2826

Closed
seanlinsley opened this issue Oct 19, 2014 · 3 comments
Closed

Speed up /about/stats #2826

seanlinsley opened this issue Oct 19, 2014 · 3 comments
Labels
Ready to Start

Comments

@seanlinsley
Copy link
Contributor

Looking at Heroku's new database performance analyzer, besides a long list of slow queries in self_check, I noticed that two queries in https://gratipay.com/about/stats were each taking a little over a second:

tip_stats

screen shot 2014-10-19 at 10 08 04 am

average_tippees

screen shot 2014-10-19 at 10 09 49 am

Loading this page in production is currently taking between 3 and 4 seconds.

Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.
@Changaco
Copy link
Contributor

The underlying issue is #1549.

@webmaven
Copy link
Contributor

Can that be alleviated at all with caching of the query results? Do you really need those queries run more often than once a day?

@nobodxbodon
Copy link
Contributor

Now loading takes <50ms. Guessing caching is in place. Closing.
screen shot 2017-01-11 at 10 20 03 pm

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Assignees
No one assigned
Labels
Ready to Start
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
5 participants
@chadwhitacre @nobodxbodon @webmaven @seanlinsley @Changaco