Upgrade to Pro — share decks privately, control downloads, hide ads and more …

A History of Fetching Specs

hone
October 18, 2013

A History of Fetching Specs

hone

October 18, 2013
Tweet

More Decks by hone

Other Decks in Programming

Transcript

  1. SELECT rv.name, rv.number, rv.platform, d.requirements, for_dep_name.name dep_name FROM (SELECT r.name,

    v.number, v.platform, v.id AS version_id FROM rubygems AS r, versions AS v WHERE v.rubygem_id = r.id AND v.indexed is true AND r.name IN ?) AS rv LEFT JOIN dependencies AS d ON d.version_id = rv.version_id LEFT JOIN rubygems AS for_dep_name ON d.rubygem_id = for_dep_name.id AND d.scope = 'runtime';
  2. Performance of Whole Index (new) 0.70s user 0.13s system 99%

    cpu 0.838 total (old) 0.70s user 0.12s system 95% cpu 0.858 total (just rails) 0.08s user 0.04s system 96% cpu 0.126 total