Database, CPU and RAM usage cut in half. Slow parts of the site targeted. Thanks to New Relic.
Long story short, viewing a script page should be much quicker now!
Looking at a chart of the slowest actions on the site we see that: updating a script, viewing the index of tags, and uploading a new version of the source of a script are the worst offenders.
Most of the slowness of updating the script is due to re-indexing into Solr. Currently that happens during the request cycle - leading to the user waiting while the search index updates. I'm planning to moving this to more of a queue based system.
I think the users and scripts index can be improved with an index as well, but will have to investigate this weekend.
Is there anything slow on the site that I (and New Relic) has missed?
You could comment on this post if you were logged in.