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( .... )
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With