After migrating to a new system, most parts work fine and perform as before. But the xml template where I use column statistics performs very bad: 8 seconds instead of 0.2 seconds on the old system. There I use statements like: ''xml.min_resolution(satellite.sensors.minimum (:min_resolution))''. Database performance is good, it is the rendering which takes a long time. When I remove the column statistics commands from the template, performance is like on the old system. The new system is using newer versions of the system software (new/ old): ruby 1.8.7/ruby 1.8.6, rails 2.2.2/rails 2.1.1, Linux 2.6.18-92.el5 (both), MySQL 5.0.45 (both). Any idea what can cause such a problem? --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
Frederick Cheung
2009-Jan-06 13:04 UTC
Re: Slow rendering (column statistics) after migration
On Jan 6, 12:55 pm, Albert <vdk...-U1TQ4twmHPk@public.gmane.org> wrote:> After migrating to a new system, most parts work fine and perform as > before. But the xml template where I use column statistics performs > very bad: 8 seconds instead of 0.2 seconds on the old system. There I > use statements like: ''xml.min_resolution(satellite.sensors.minimum > (:min_resolution))''. Database performance is good, it is the rendering > which takes a long time. When I remove the column statistics commands > from the template, performance is like on the old system. >I suggest you get ruby-prof and see where the time is going. Fred> The new system is using newer versions of the system software (new/ > old): ruby 1.8.7/ruby 1.8.6, rails 2.2.2/rails 2.1.1, Linux > 2.6.18-92.el5 (both), MySQL 5.0.45 (both). > > Any idea what can cause such a problem?--~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---