Well, I think I found the inverse of :ignore. I tried :select => [
'field_1', ... 'field_n'], excluding the 'big_column' as an argument to
apply_scopes and the search and sort became much faster. I looked at
the log and the big_column data were missing, so I think I have it.
Don Z.
On 5/24/2011 1:08 PM, Donald R. Ziesig wrote:
Hi All:
I have some tables with large (in terms of data size) columns. When I
use apply scopes, specifically to sort and search, these tables take
significantly longer than the other tables. As an experiment, I
duplicated a table, removed the large column and tried the sort/search
and it worked as fast as the tables without large columns.
I need something like :ignore => 'big_column' which would remove
big_column from the SQL query before anything is done.
Thanks,
Don Z.
--
You received this message because you are subscribed to the Google Groups "Hobo
Users" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/hobousers?hl=en.
