Check out the Issue Explorer
Looking to fund some work? You can submit a new Funded Issue here.
Loading the Top Accounts list is very slow.
Also, after the page is loaded, the count of transactions per account seems to be wrong.
## Steps to Reproduce
During the standup meeting (11/06/18) we commonly agreed that some changes were needed to enable this query (list_top_addresses) on the mainnet. In this agreement, we decided to simplify the query by removing the transaction count from it and also adding a new index to improve its performance.
The previous test result using the mainnet can be consulted in this PR: https://github.com/poanetwork/blockscout/pull/1040
### Acceptance Criteria
1) Be able to execute the query on the mainnet database as well;
2) Be able to load the Top Accounts listing page again without returning a ```Gateway Timeout``` error;