I would have a look at the MiniSQL gem also, which we're using to generate dropdown lists, for example, and which is very efficient indeed.
One technique we've also used very effectively is to embed logic in views and place an ActiveRecord model on top of them. The scenic gem is useful for that, and it hides the SQL from your Ruby developers – they just get really fast processing!
Good stuff.
I would have a look at the MiniSQL gem also, which we're using to generate dropdown lists, for example, and which is very efficient indeed.
One technique we've also used very effectively is to embed logic in views and place an ActiveRecord model on top of them. The scenic gem is useful for that, and it hides the SQL from your Ruby developers – they just get really fast processing!
Wow. I've checked them out and they are really interesting solutions.
MiniSQL gem looks really good due to its simplicity and fast! Certainly something I will consider using in the future ;)
Thanks for you input!