Thanks Andy, For ur quick reply and valuable suggestion. I followed your suggestion and It improved performance and decrease the no. of db queries.
Thanks Andy Jeffries wrote: >> > Sure: > > usedpermlicence = @licences.select {|o| o.status == 1 && o.licence_type > == > 0} > usedtemplicence = @licences.select {|o| o.status == 1 && o.licence_type > == > 1} > > etc... > > You can treat @licences as an array and just select the items you want. > One > DB query (which you're already doing) and a quick bit of filtering. > > http://ruby-doc.org/core/classes/Array.html#M002191 > > Cheers, > > > Andy -- Posted via http://www.ruby-forum.com/. -- 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-t...@googlegroups.com. To unsubscribe from this group, send email to rubyonrails-talk+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.