Lighthouse has a new layout. Prefer the old one? Return to the old layout, and switch back any time from the link at the top of each page.

This project is archived and is in readonly mode.

Major ActiveRecord slowness

#5309

ActiveRecord performs increasingly poorly as the result set size increases in 3.0.0.rc.

I get this strace output at least once (if not more) for every object in the result (ChildA is the AR class):

rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
stat("/application/app/helpers/child_a/child_a.rb", 0x7fffb53d1290) = -1 ENOENT (No such file or directory)
stat("/application/app/models/child_a/child_a.rb", 0x7fffb53d1290) = -1 ENOENT (No such file or directory)
stat("/application/app/middleware/child_a/child_a.rb", 0x7fffb53d1290) = -1 ENOENT (No such file or directory)
stat("/application/app/controllers/child_a/child_a.rb", 0x7fffb53d1290) = -1 ENOENT (No such file or directory)
stat("/application/app/helpers/child_a/child_a", 0x7fffb53d00e0) = -1 ENOENT (No such file or directory)
stat("/application/app/models/child_a/child_a", 0x7fffb53d00e0) = -1 ENOENT (No such file or directory)
stat("/application/app/middleware/child_a/child_a", 0x7fffb53d00e0) = -1 ENOENT (No such file or directory)
stat("/application/app/controllers/child_a/child_a", 0x7fffb53d00e0) = -1 ENOENT (No such file or directory)

This is when running in development mode. No idea if production mode has the same issue.

Reported by Blane Dabney · August 5th, 2010 @ 04:51 PM

State: resolved
Milestone: none
Assigned to: nobody
Importance: Low

Activity

  1. Rohit Arondekar
    Rohit Arondekar
    • State changed from new to resolved
    • Tag set to activerecord
    • Importance changed from to Low

    A lot of work has been done by Aaron Patterson with regards to AR performance both before and after 3.0 release. There has been a lot of improvements in performance.

    Marking ticket as resolved. In case the above issue is still happening in 3.0 or 3-0-stable branch or even master just leave a comment and I'll reopen it.

    October 7th, 2010 @ 05:27 AM