Comparing application performance on Rackspace vs Google Compute Engine

gistfile1.rb

Started GET "/books" for 96.226.128.2 at 2013-10-22 20:18:56 +0000
  Processing by Web::BooksController#index as HTML
  User Load (2.7ms)  SELECT `users`.* FROM `users` WHERE `users`.`id` = 38 LIMIT 1
   (2.4ms)  SELECT COUNT(*) FROM `reading_actions` WHERE `reading_actions`.`user_id` = 38 AND `reading_actions`.`action_type` = 'have_read'
   (75.2ms)  SELECT COUNT(*) FROM `reading_actions` WHERE `reading_actions`.`user_id` = 38 AND `reading_actions`.`action_type` = 'want_to_read'
   (54.7ms)  SELECT COUNT(*) FROM `reading_actions` LEFT OUTER JOIN readings ON readings.reading_action_id = reading_actions.id WHERE `reading_actions`.`user_id` = 38 AND (reading_actions.readable_type in ('Book', 'SocialBook') AND reading_actions.action_type = 'reading_now') AND (CASE WHEN readings.is_private = 1 THEN readings.user_id = 38 ELSE 1 = 1 END)
Rendered shared/v2/_breadcrumb.haml (2.3ms)
   (2.8ms)  SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM `reading_actions` LEFT OUTER JOIN readings ON readings.reading_action_id = reading_actions.id WHERE `reading_actions`.`user_id` = 38 AND (reading_actions.readable_type in ('Book', 'SocialBook') AND reading_actions.action_type = 'reading_now') AND (CASE WHEN readings.is_private = 1 THEN readings.user_id = 38 ELSE 1 = 1 END) LIMIT 16) subquery_for_count
  ReadingAction Load (19.9ms)  SELECT reading_actions.*, readings.id as reading_id, readings.read_buckets as reading_read_buckets,
 readings.is_private as reading_is_private, readings.reading_type as reading_reading_type, readings.last_opened_at as reading_last_opened_at,
 readings.created_at as reading_created_at, readings.updated_at as reading_updated_at FROM `reading_actions` LEFT OUTER JOIN readings ON readings.reading_action_id = reading_actions.id WHERE `reading_actions`.`user_id` = 38 AND (reading_actions.readable_type in ('Book', 'SocialBook') AND reading_actions.action_type = 'reading_now') AND (CASE WHEN readings.is_private = 1 THEN readings.user_id = 38 ELSE 1 = 1 END) ORDER BY readings.last_opened_at desc LIMIT 16
  Book Load (478.0ms)  SELECT `books`.* FROM `books` WHERE `books`.`id` IN (35924, 1262, 31357, 35546, 31640, 188727, 36927, 188726, 44140, 76018, 12007, 70552, 87701, 46407, 62165, 12517)
   (2.8ms)  SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM `reading_actions` LEFT OUTER JOIN readings ON readings.reading_action_id = reading_actions.id WHERE `reading_actions`.`user_id` = 38 AND (reading_actions.readable_type in ('Book', 'SocialBook') AND reading_actions.action_type = 'have_read') AND (CASE WHEN readings.is_private = 1 THEN readings.user_id = 38 ELSE 1 = 1 END) LIMIT 12) subquery_for_count
-------------------------------------------

Started GET "/books" for 96.226.128.2 at 2013-10-22 20:40:06 +0000
  Processing by Web::BooksController#index as HTML
  User Load (2.7ms)  SELECT `users`.* FROM `users` WHERE `users`.`id` = 38 LIMIT 1
   (2.4ms)  SELECT COUNT(*) FROM `reading_actions` WHERE `reading_actions`.`user_id` = 38 AND `reading_actions`.`action_type` = 'have_read'
   (2.2ms)  SELECT COUNT(*) FROM `reading_actions` WHERE `reading_actions`.`user_id` = 38 AND `reading_actions`.`action_type` = 'want_to_read'
   (3.5ms)  SELECT COUNT(*) FROM `reading_actions` LEFT OUTER JOIN readings ON readings.reading_action_id = reading_actions.id WHERE `reading_actions`.`user_id` = 38 AND (reading_actions.readable_type in ('Book', 'SocialBook') AND reading_actions.action_type = 'reading_now') AND (CASE WHEN readings.is_private = 1 THEN readings.user_id = 38 ELSE 1 = 1 END)
Rendered shared/v2/_breadcrumb.haml (1.9ms)
   (2.7ms)  SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM `reading_actions` LEFT OUTER JOIN readings ON readings.reading_action_id = reading_actions.id WHERE `reading_actions`.`user_id` = 38 AND (reading_actions.readable_type in ('Book', 'SocialBook') AND reading_actions.action_type = 'reading_now') AND (CASE WHEN readings.is_private = 1 THEN readings.user_id = 38 ELSE 1 = 1 END) LIMIT 16) subquery_for_count
   
------------------------------------------------