Skip to content

Instantly share code, notes, and snippets.

@tpitale
Created July 30, 2009 12:49
Show Gist options
  • Select an option

  • Save tpitale/158673 to your computer and use it in GitHub Desktop.

Select an option

Save tpitale/158673 to your computer and use it in GitHub Desktop.
time psql feedstitch_development -qt -c 'SELECT entries.* FROM entries INNER JOIN group_entries ON entries.id = group_entries.entry_id WHERE (group_entries.group_id IN (SELECT id FROM groups WHERE user_id = 1)) ORDER BY entries.published_at DESC LIMIT 10000' &> /dev/null
time mysql feedstitch_development -e 'SELECT entries.* FROM entries INNER JOIN group_entries ON entries.id = group_entries.entry_id WHERE (group_entries.group_id IN (SELECT id FROM groups WHERE user_id = 1)) ORDER BY entries.published_at DESC LIMIT 10000' &> /dev/null
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment