search

everypolitician / gender-balance

Crowdsourcing platform for gathering gender information about politicians to improve the data in EveryPolitician
gender-balance.org
15 stars 3 forks source link

Add indexes to country_uuids.uuid and votes.person_uuid #353

Closed chrismytton closed 8 years ago

chrismytton commented 8 years ago

When generating the CSV export we do a join between these two tables on these two columns. For legislatures with lots of people, like Greece, this was starting to get very slow on Heroku. This change should help to keep the CSV export snappy and prevent timeouts.