Latest posts by Chris Downey (see all)
- Dramatic improvement by replacing ActiveRecord loop with single SQL query - March 17, 2017
- Activist best practice: auto-archiving web pages - February 4, 2017
- Pre-calculating vaccine ingredients: from PostgreSQL to HTML data-* - February 1, 2017
After bringing the production database down to my local dev machine and restoring it in order to use the latest data to develop against, I could no longer load the Dashboard for my @VaxCalc account as it kept timing out. Autovist has posted more than 25,000 tweets for @VaxCalc tracking multiple broadcasts of each tweet, url clicks and RTs for each of the broadcasts. Was this large number of tweets killing performance somehow?