Recently upgraded our gems to the most recent beta gems, and found that our app runs about 10-20x slower. Db requests are still fast, but there was a noticeable lag between each step in the process to render a page (when tailing the log). Reverting back to our previous set of gems (0.14.2.2825) resolved the issue. Is anyone aware of the cause? Any guesses? I''m happy to help debug, but if somebody has a sense as to where/when the problem cropped up...
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Nov 11, 2005, at 2:54 PM, Michael Schoen wrote:> Recently upgraded our gems to the most recent beta gems, and found > that our app runs about 10-20x slower. Db requests are still fast, > but there was a noticeable lag between each step in the process to > render a page (when tailing the log). > > Reverting back to our previous set of gems (0.14.2.2825) resolved > the issue. > > Is anyone aware of the cause? Any guesses? I''m happy to help debug, > but if somebody has a sense as to where/when the problem cropped up...Any luck tracking this down, Michael? I''m not seeing a slowdown here. jeremy -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.2 (Darwin) iD8DBQFDdmnxAQHALep9HFYRAkxOAKChHCaZOXpMnfEXZtmOmjlfug5o5ACgkrTI 30z3w+HLIi3eziKLSHoP7yw=3MnF -----END PGP SIGNATURE-----
>> Is anyone aware of the cause? Any guesses? I''m happy to help debug, >> but if somebody has a sense as to where/when the problem cropped up... > > > Any luck tracking this down, Michael? > I''m not seeing a slowdown here.I was waiting a bit to see if anyone had any clues. I''ll see what I can figure out.
>> Any luck tracking this down, Michael? >> I''m not seeing a slowdown here. > > I was waiting a bit to see if anyone had any clues. I''ll see what I can > figure out.Ok, not much progress yet, though it''s an issue AFTER 0.14.3. With 0.14.3, my sample request completes in about 0.10 seconds. After upgrading to the latest gems (.2969), that same request takes over 4.5 seconds to complete, so 45x slower. The gems on rev 2960 had the same issue. I''ll start tracing through the changes made between 2931 and 2960.
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Nov 12, 2005, at 8:31 PM, Michael Schoen wrote:>>> Any luck tracking this down, Michael? >>> I''m not seeing a slowdown here. >> I was waiting a bit to see if anyone had any clues. I''ll see what >> I can figure out. > > Ok, not much progress yet, though it''s an issue AFTER 0.14.3. > > With 0.14.3, my sample request completes in about 0.10 seconds. > After upgrading to the latest gems (.2969), that same request takes > over 4.5 seconds to complete, so 45x slower. The gems on rev 2960 > had the same issue. > > I''ll start tracing through the changes made between 2931 and 2960.These touch sessioning (the likely culprit?) and the Oracle and MySQL adapters. jeremy -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.2 (Darwin) iD8DBQFDdtxWAQHALep9HFYRAp12AJ9i2aNcPtBHfgRj2+al0H2k0MEwpQCfXahI hYsfaZasG0dFGNkPBlcZqG0=ISV9 -----END PGP SIGNATURE-----
>> I''ll start tracing through the changes made between 2931 and 2960. > > These touch sessioning (the likely culprit?) and the Oracle and MySQL > adapters.Ugh, bitten by my own patch. Turns out that the improvement in the column reflection sql in changeset 2935 dramatically hurt the performance in the normal case. And in dev mode, w/ column reflection done on each request, it hurt bad. Fixed in new patch, just submitted: http://dev.rubyonrails.com/ticket/2848 thanks, Michael