|| at Jun 7, 2012 at 10:24 am
Ok thanks a lot ..
in the meantime , I modified my record design , adding a ds_name
string which is the lower(name) written upon create, so I can order on
as it's for 'tag' records, I'll not have billion of records ..
according to your feedback I can create a case-insensitive index on
the column.. even better
On Jun 6, 10:16 pm, Robert Walker wrote:
Robert Walker wrote in post #1063410:
orders = Order.order('lower(name)')
Order Load (0.5ms) SELECT "orders".* FROM "orders" ORDER BY
Keep in mind that the above will force the database to perform a
sequential scan of the table even if the column you're ordering by is
indexed. Which means that if you have performance issues you may need to
create a case-insensitive index on the column. I'll leave that as an
exercise for you on how to set that up in whatever database you are
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 email@example.com.
To unsubscribe from this group, send email to firstname.lastname@example.org.
For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.