#5309 Major ActiveRecord slowness - Ruby on Rails

Type	To find
responsible:me	tickets assigned to you
tagged:"@high"	tickets tagged @high
milestone:next	tickets in the upcoming milestone
state:invalid	tickets with the state invalid
created:"last week"	tickets created last week
sort:number, importance, updated	tickets sorted by #, importance or updated
Combine keywords for powerful searching.
Use advanced searching »

This project is archived and is in readonly mode.

#5309 ✓resolved

Major ActiveRecord slowness

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

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.

Comments and changes to this ticket

Rohit Arondekar October 7th, 2010 @ 05:27 AM
- 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.