This is what I get in the log files when accessing a page with ~8 photos on it. Notice the big fat (Rendering: 6.42337 (97%) ) at the bottom. It can be seen that the https connection is continually opened and closed which is probably responsible for most of the slow down. Are things normally like this? Thanks ================================SHOW FIELDS FROM `content_photos` New RightAws::S3Interface using single-threaded mode Closing HTTPS connection to my_app.s3.amazonaws.com:443 Opening new HTTPS connection to s3.amazonaws.com:443 warning: peer certificate won''t be verified in this SSL session warning: peer certificate won''t be verified in this SSL session warning: peer certificate won''t be verified in this SSL session Rendered admin/content_photos/_content_photo (0.46094) New RightAws::S3Interface using single-threaded mode Closing HTTPS connection to s3.amazonaws.com:443 Opening new HTTPS connection to my_app.s3.amazonaws.com:443 Closing HTTPS connection to my_app.s3.amazonaws.com:443 Opening new HTTPS connection to s3.amazonaws.com:443 Rendered admin/content_photos/_content_photo (0.74744) New RightAws::S3Interface using single-threaded mode Closing HTTPS connection to s3.amazonaws.com:443 Opening new HTTPS connection to my_app.s3.amazonaws.com:443 warning: peer certificate won''t be verified in this SSL session warning: peer certificate won''t be verified in this SSL session warning: peer certificate won''t be verified in this SSL session Closing HTTPS connection to my_app.s3.amazonaws.com:443 Opening new HTTPS connection to s3.amazonaws.com:443 Rendered admin/content_photos/_content_photo (0.66900) New RightAws::S3Interface using single-threaded mode Closing HTTPS connection to s3.amazonaws.com:443 Opening new HTTPS connection to my_app.s3.amazonaws.com:443 Closing HTTPS connection to my_app.s3.amazonaws.com:443 Opening new HTTPS connection to s3.amazonaws.com:443 warning: peer certificate won''t be verified in this SSL session warning: peer certificate won''t be verified in this SSL session warning: peer certificate won''t be verified in this SSL session Rendered admin/content_photos/_content_photo (0.67587) New RightAws::S3Interface using single-threaded mode Closing HTTPS connection to s3.amazonaws.com:443 Opening new HTTPS connection to my_app.s3.amazonaws.com:443 Closing HTTPS connection to my_app.s3.amazonaws.com:443 Opening new HTTPS connection to s3.amazonaws.com:443 Rendered admin/content_photos/_content_photo (0.65983) New RightAws::S3Interface using single-threaded mode Closing HTTPS connection to s3.amazonaws.com:443 Opening new HTTPS connection to my_app.s3.amazonaws.com:443 warning: peer certificate won''t be verified in this SSL session warning: peer certificate won''t be verified in this SSL session Closing HTTPS connection to my_app.s3.amazonaws.com:443 Opening new HTTPS connection to s3.amazonaws.com:443 Rendered admin/content_photos/_content_photo (0.62771) New RightAws::S3Interface using single-threaded mode Closing HTTPS connection to s3.amazonaws.com:443 Opening new HTTPS connection to my_app.s3.amazonaws.com:443 warning: peer certificate won''t be verified in this SSL session warning: peer certificate won''t be verified in this SSL session warning: peer certificate won''t be verified in this SSL session Closing HTTPS connection to my_app.s3.amazonaws.com:443 Opening new HTTPS connection to s3.amazonaws.com:443 Rendered admin/content_photos/_content_photo (0.84993) New RightAws::S3Interface using single-threaded mode Closing HTTPS connection to s3.amazonaws.com:443 Opening new HTTPS connection to my_app.s3.amazonaws.com:443 Closing HTTPS connection to my_app.s3.amazonaws.com:443 Opening new HTTPS connection to s3.amazonaws.com:443 Rendered admin/content_photos/_content_photo (0.63834) ContentFile Load (0.001071) SELECT * FROM `content_files` WHERE (content_files.content_id = 1) ContentFile Columns (0.004495) SHOW FIELDS FROM `content_files` Rendered admin/content_files/_content_file (0.00858) Rendered admin/content_files/_content_file (0.00076) Page Load (0.001569) SELECT * FROM `pages` WHERE (pages.deleted_at IS NULL OR pages.deleted_at > ''2008-04-12 23:08:47'') AND (pages.account_id = 1 AND (name = ''Main'')) LIMIT 1 Completed in 6.56130 (0 reqs/sec) | Rendering: 6.42337 (97%) | DB: 0.03947 (0%) | 200 OK [http://localhost/admin/pages/1-Main/contents/1] --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
I made some changes to prevent accessing all the files through an ssl connection, but it is still at about 3 seconds to download. (Actually the files are missing on the s3 server so it is really taking three seconds to find out that the files are not there). The RightAws::S3Interface has also been changed from single-threaded mode to multi-threaded mode, but with very little, if any difference. Can this be made any better? On Apr 12, 11:26 pm, chris <olsen.ch...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> This is what I get in the log files when accessing a page with ~8 > photos on it. Notice the big fat (Rendering: 6.42337 (97%) ) at the > bottom. > > It can be seen that the https connection is continually opened and > closed which is probably responsible for most of the slow down. > > Are things normally like this? > > Thanks > > ================================> SHOW FIELDS FROM `content_photos` > New RightAws::S3Interface using single-threaded mode > Closing HTTPS connection to my_app.s3.amazonaws.com:443 > Opening new HTTPS connection to s3.amazonaws.com:443 > warning: peer certificate won''t be verified in this SSL session > warning: peer certificate won''t be verified in this SSL session > warning: peer certificate won''t be verified in this SSL session > Rendered admin/content_photos/_content_photo (0.46094) > New RightAws::S3Interface using single-threaded mode > Closing HTTPS connection to s3.amazonaws.com:443 > Opening new HTTPS connection to my_app.s3.amazonaws.com:443 > Closing HTTPS connection to my_app.s3.amazonaws.com:443 > Opening new HTTPS connection to s3.amazonaws.com:443 > Rendered admin/content_photos/_content_photo (0.74744) > New RightAws::S3Interface using single-threaded mode > Closing HTTPS connection to s3.amazonaws.com:443 > Opening new HTTPS connection to my_app.s3.amazonaws.com:443 > warning: peer certificate won''t be verified in this SSL session > warning: peer certificate won''t be verified in this SSL session > warning: peer certificate won''t be verified in this SSL session > Closing HTTPS connection to my_app.s3.amazonaws.com:443 > Opening new HTTPS connection to s3.amazonaws.com:443 > Rendered admin/content_photos/_content_photo (0.66900) > New RightAws::S3Interface using single-threaded mode > Closing HTTPS connection to s3.amazonaws.com:443 > Opening new HTTPS connection to my_app.s3.amazonaws.com:443 > Closing HTTPS connection to my_app.s3.amazonaws.com:443 > Opening new HTTPS connection to s3.amazonaws.com:443 > warning: peer certificate won''t be verified in this SSL session > warning: peer certificate won''t be verified in this SSL session > warning: peer certificate won''t be verified in this SSL session > Rendered admin/content_photos/_content_photo (0.67587) > New RightAws::S3Interface using single-threaded mode > Closing HTTPS connection to s3.amazonaws.com:443 > Opening new HTTPS connection to my_app.s3.amazonaws.com:443 > Closing HTTPS connection to my_app.s3.amazonaws.com:443 > Opening new HTTPS connection to s3.amazonaws.com:443 > Rendered admin/content_photos/_content_photo (0.65983) > New RightAws::S3Interface using single-threaded mode > Closing HTTPS connection to s3.amazonaws.com:443 > Opening new HTTPS connection to my_app.s3.amazonaws.com:443 > warning: peer certificate won''t be verified in this SSL session > warning: peer certificate won''t be verified in this SSL session > Closing HTTPS connection to my_app.s3.amazonaws.com:443 > Opening new HTTPS connection to s3.amazonaws.com:443 > Rendered admin/content_photos/_content_photo (0.62771) > New RightAws::S3Interface using single-threaded mode > Closing HTTPS connection to s3.amazonaws.com:443 > Opening new HTTPS connection to my_app.s3.amazonaws.com:443 > warning: peer certificate won''t be verified in this SSL session > warning: peer certificate won''t be verified in this SSL session > warning: peer certificate won''t be verified in this SSL session > Closing HTTPS connection to my_app.s3.amazonaws.com:443 > Opening new HTTPS connection to s3.amazonaws.com:443 > Rendered admin/content_photos/_content_photo (0.84993) > New RightAws::S3Interface using single-threaded mode > Closing HTTPS connection to s3.amazonaws.com:443 > Opening new HTTPS connection to my_app.s3.amazonaws.com:443 > Closing HTTPS connection to my_app.s3.amazonaws.com:443 > Opening new HTTPS connection to s3.amazonaws.com:443 > Rendered admin/content_photos/_content_photo (0.63834) > ContentFile Load (0.001071) SELECT * FROM `content_files` WHERE > (content_files.content_id = 1) > ContentFile Columns (0.004495) SHOW FIELDS FROM `content_files` > Rendered admin/content_files/_content_file (0.00858) > Rendered admin/content_files/_content_file (0.00076) > Page Load (0.001569) SELECT * FROM `pages` WHERE (pages.deleted_at > IS NULL OR pages.deleted_at > ''2008-04-12 23:08:47'') AND > (pages.account_id = 1 AND (name = ''Main'')) LIMIT 1 > Completed in 6.56130 (0 reqs/sec) | Rendering: 6.42337 (97%) | DB: > 0.03947 (0%) | 200 OK [http://localhost/admin/pages/1-Main/contents/1]--~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
Chris Olsen wrote:> I made some changes to prevent accessing all the files through an ssl > connection, but it is still at about 3 seconds to download. (Actually > the files are missing on the s3 server so it is really taking three > seconds to find out that the files are not there). > > The RightAws::S3Interface has also been changed from single-threaded > mode to multi-threaded mode, but with very little, if any difference. > > Can this be made any better?Hi Chris, What were the changes you made to prevent the accessing of files via ssl? I''m experiencing the same slowness and am trying to figure out how to get a http connection to access the S3 files instead. Thanks. -- Posted via http://www.ruby-forum.com/.