I broke up the offense, defense joins in half and ran a new test... 20 ms (winner)..
I still get all my data so with the indexes in place, the join splits, it looks good - I'll have to do some extensive testing though to see how it load balances in production.. Many thanks everyone. I really appreciate the help with this optimization. -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ 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 protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
