chainquery
chainquery copied to clipboard
Add index on "effective_amount" in claims table
If we want to fetch statistics on content on Chainquery, such as Top claims, we need to have an index on the effective_amount column. https://chainquery.lbry.io/api/sql?query=SELECT%20*%20from%20claim%20order%20by%20effective_amount%20desc%20LIMIT%2010
Otherwise, the query is too slow. It would open a world of possibilities for statistics based on Chainquery.