Hello all, I'm working on optimising database accesses in my Rails application. I'm having a master model and a logging model. For each master there may be many logging objects, so the master has_many logging objects and the logging object belongs_to master object. I'd like to quickly fetch the most recently received logging object for a master, preferably within a join, so that I can sort and filter in SQL rather than in Rails. But I can't simply use :include => logging model because there are many of the for a single master. Is there some possible and elegant solution/workaround of this problem in Rails? I'm currently replicating the most recently received loging object for each machine in a separate table, but since the database is updated by other programs I'm afraid of consitency errors.
on 2007-03-14 13:58