What is the way in rails to structure sql query to only select certain columns from the database, I have some large data fields which I want to avoid loading from continuous periodic ajax calls. Reading unnecessarily is resource consuming and slow.
@itemlist = Item.find(:all, :conditions => { .... } ) #this select all columns
I am looking for SELECT name, address FROM users;
instead of SELECT * FROM users;
Rails 3:
Item.select("name, address").where( .... )